About Us

Don Guillett[_4_]

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I make a blank cell in a formula cell with a range of cell	Vi	Excel Discussion (Misc queries)	5	June 21st 07 02:46 PM
adding a formula in a cell but when cell = 0 cell is blank	Mike T	Excel Worksheet Functions	5	May 31st 05 01:08 AM
Cell Formula reference to cell Based On third Cell Content	Gabriel	Excel Discussion (Misc queries)	1	February 11th 05 06:36 AM
Cell Formula reference to cell Based On third Cell Content	Gabriel	Excel Discussion (Misc queries)	0	February 11th 05 05:35 AM
Question: Cell formula or macro to write result of one cell to another cell	Frederik Romanov	Excel Programming	1	July 8th 03 03:03 PM