Thread
:
How to tell whether a cell contains a formula?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
How to tell whether a cell contains a formula?
Oops.
--
Don Guillett
SalesAid Software
Granite Shoals, TX
"Tom Ogilvy" wrote in message
...
I belive that is
if range("A12").hasformula then
but that would be true for
=pi()*2000
which doesn't refer to a another cell (but maybe he didn't mean to exclude
those).
Regards,
Tom Ogilvy
"Don Guillett" wrote in message
...
if isformula([a12])
--
Don Guillett
SalesAid Software
Granite Shoals, TX
"Seihee" wrote in message
...
Hi!
I'm writing a macro to examine all cells in a worksheet.
If a cell contains a "pure formula" referencing other
cells, then I want to change the color of the cell that
contains a formula.
In a macro, is there any way I can tell whether a cell
contains a formula rather than pure values (number,
literal, etc.)?
By "pure formula", I mean a formula that contain a cell
reference. In other words, "=b5+k2" will be considered a
formula but "=5+28/4" will not for my purposes.
Your help will be greatly appreciated.
Thanks,
Seihee
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]