Palosishe
03-31-2015, 12:03 PM
Hello everyone.
Can someone please help me with this problem? I would really appreciate it.
Write a general purpose sub that opens a particular workbook, such as C:\MyFiles\Company Data.xlsx, adds a new worksheet named Formula List afterthe original worksheets, and then goes through all of the original worksheetshunting for cells with formulas. Each time it finds a formula, it records informationabout it in a new row of the Formula List worksheet. Specifically, it recordsthe worksheet’s name in column A, it records the formula as a string in column B,and it records the formula’s value in column C. (Hint: To check whether a cellcontains a formula, use VBA’s HasFormula property of a range.)
Can someone please help me with this problem? I would really appreciate it.
Write a general purpose sub that opens a particular workbook, such as C:\MyFiles\Company Data.xlsx, adds a new worksheet named Formula List afterthe original worksheets, and then goes through all of the original worksheetshunting for cells with formulas. Each time it finds a formula, it records informationabout it in a new row of the Formula List worksheet. Specifically, it recordsthe worksheet’s name in column A, it records the formula as a string in column B,and it records the formula’s value in column C. (Hint: To check whether a cellcontains a formula, use VBA’s HasFormula property of a range.)