Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Info function which identfies a formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Info function which identfies a formula
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 --- "ArthurJ" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Info function which identfies a formula
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/Writin...ionsInVBA.aspx -- Gary''s Student - gsnu200809 "ArthurJ" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FUNCTION that reads 7 worksheets and brings info into another work | Excel Worksheet Functions | |||
What function-bring me the info in the next column-same row? | Excel Worksheet Functions | |||
IF function? Moving the same info from one worksheet to another. | Excel Worksheet Functions | |||
lookup function bringing in wrong info | Excel Worksheet Functions | |||
Is there a function that will return info of the cursor location? | Excel Worksheet Functions |