Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to tell whether a cell contains a formula?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |