Total number of Formula used in a Spreadsheet ?

P

Paul Taylor

Hi all,

A member of my accounts team is asking if there is anyway to find out
the total number of Formula's used in a Spreadsheet.

I am not sure this is even possible. Does anyone have any ideas ??.

Many Thanks,
Paul Taylor.
 
G

Gary''s Student

Enter the following macro:

Sub funcount()
Dim iamthecount As Double
Dim cell As Range
iamthecount = 0
For Each cell In Selection
If cell.HasFormula Then
iamthecount = iamthecount + 1
End If
Next
MsgBox (iamthecount)
End Sub

Then go back to a worksheet and select whatever range of cells you want and
run the macro. It will tell you the number of cells containing functions or
formula in your selection.
 
A

Alan

Try 'Edit' > 'Goto' > 'Special' > Check 'Formulas' > OK. This will highlight
all the formulas on that sheet. Right click on the Status Bar and click
'Count'. Repeat for all the other sheets,
Regards,
Alan.

"Paul Taylor" <[email protected]>
wrote in message
news:p[email protected]...
 
Top