Determining if Cell has Formula
maybe one of these:
If ActiveCell.HasFormula = True Then
MsgBox ActiveCell.Address & " contains a formula"
End If
If Range("A1").HasFormula = True Then
MsgBox Range("A1").Address & " contains a formula"
End If
--
Gary
Excel 2003
"PosseJohn" wrote in message
...
I have a worksheet that contains formulas that are linked dynamically to an
outside source. I have created a Workbook_BeforeClose routine that asks
the
user if formulas should be removed from the worksheet (to lock in the
values
from outside source).
If the formulas have already been removed, I don't want to ask the user
about formulas that have already been removed.
How can I determine if a specific cell contains a formula or an actual
value?
|