Hello everyone,
Can someone please help me with this problem?
Write a general purpose sub that opens a particular workbook, such as C:\ MyFiles\Company Data.xlsx, adds a new worksheet named Formula List after the original worksheets, and then goes through all of the original worksheets hunting for cells with formulas. Each time it finds a formula, it records information about it in a new row of the Formula List worksheet. Specifically, it records the 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 cell contains a formula, use VBA’s HasFormula property of a range.)
Can someone please help me with this problem?
Write a general purpose sub that opens a particular workbook, such as C:\ MyFiles\Company Data.xlsx, adds a new worksheet named Formula List after the original worksheets, and then goes through all of the original worksheets hunting for cells with formulas. Each time it finds a formula, it records information about it in a new row of the Formula List worksheet. Specifically, it records the 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 cell contains a formula, use VBA’s HasFormula property of a range.)