Posted to microsoft.public.excel.misc
|
|
=ISFUNCTION
For my own curiousity...
Why mark the function volatile?
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Gary''s Student" wrote:
Try this small UDF:
Public Function IsFormula(r As Range) As Boolean
Application.Volatile
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 - gsnu200909
"Neil Pearce" wrote:
Hi there,
Thank you.
That is great for locating those cells which contain a formula. However I
am hoping to create a formula such that conditional formatting will highlight
a cell if that cell no longer caontinas a formula but is instead overwriten
with a hard number by a user.
e.g. NOT(ISFORMULA(A1)) then fill cell yellow.
"JLatham" wrote:
Edit -- Go To -- [Special] and choose Formulas and the sub option(s) in
that list for the type of results, Number, text, etc, that you are looking
for.
"Neil Pearce" wrote:
All,
I am aware of the IS forumlae. But how would I test if a cell is a function
that calucates a number as opposed to a hard inputted number? The end goal
being to highlight any cells where a formula is overwritten using conditonal
formatting.
The forumla in question being:
=IF(NOT(B9=""),VLOOKUP(B9,'Project Overview'!$A$34:$E$52,COLUMNS('Project
Overview'!$A$33:$E$33),FALSE),0)
Appreciated as always,
Neil
|