Excel Cell Reference 1

[simoncpage]

Hi all, How can I check if a cell contains a value or a formula?

Thanks
Simon

 

[RobBroekhuis]

There may be a more elegant way, but a simple way is to check for the equals sign:

if left(activecell.formula,1)="=" then
...it's a formula...
else
...it's just a value
end if

Rob