Home |
Search |
Today's Posts |
#1
|
|||
|
|||
test for a formula
Will someone help me write a macro to check if a selected cell contains a
formula. Please |
#2
|
|||
|
|||
Hi Lashio,
Try something like: '================= Public Sub FormulaTest() If ActiveCell.HasFormula Then 'Do something, e.g.: MsgBox "Cell " & ActiveCell.Address(0, 0) _ & " is a formula cell" Else 'do something else, e.g.: MsgBox "Cell " & ActiveCell.Address(0, 0) _ & " is not a formula cell" End If End Sub '<<================= --- Regards, Norman "lashio" wrote in message ... Will someone help me write a macro to check if a selected cell contains a formula. Please |
#3
|
|||
|
|||
Hi Norman,
Thank you very much, that's what I needed. "Norman Jones" wrote in message ... Hi Lashio, Try something like: '================= Public Sub FormulaTest() If ActiveCell.HasFormula Then 'Do something, e.g.: MsgBox "Cell " & ActiveCell.Address(0, 0) _ & " is a formula cell" Else 'do something else, e.g.: MsgBox "Cell " & ActiveCell.Address(0, 0) _ & " is not a formula cell" End If End Sub '<<================= --- Regards, Norman "lashio" wrote in message ... Will someone help me write a macro to check if a selected cell contains a formula. Please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |