Info function which identfies a formula

[ArthurJ]

I have long columns consisting of numbers, formulas, and blanks. I need an
info type function that returns true for a cell containing a formula. Does
that exist, or is there a way to do this?

Thanks,
Art

 

[Max]

Press F5 > Special > Check Formulas > OK
will select all cells with formulas in the sheet

You could then format to taste at one go, etc
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik

 

[Gary''s Student]

Hi Art:

Here is a User Defined Function that you can try:

Function isformula(r As Range) As Boolean
isformula = r.HasFormula
End Function


UDFs are very easy to install and use:

1. ALT-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste the stuff in and close the VBE window

If you save the workbook, the UDF will be saved with it.

To use the UDF from the normal Excel window, just enter it like a normal
Excel Function

To remove the UDF:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To learn more about UDFs, see:

http://www.cpearson.com/excel/WritingFunctionsInVBA.aspx