Quick question.

Is there a VBA command that tests the activecell to see if it contains a
formula as opposed to actual text or number?
I've found tests for errors, dates, numbers, text etc.
You can test for "=" as it tests the value of the cell.

Prob really simple but I'm baffled.

Cheers
Giz

On Thu, 23 Nov 2006 06:45:02 -0800, Gizmo63
wrote:

Quick question.

Is there a VBA command that tests the activecell to see if it contains a
formula as opposed to actual text or number?
I've found tests for errors, dates, numbers, text etc.
You can test for "=" as it tests the value of the cell.

Prob really simple but I'm baffled.

Cheers
Giz


Function HasFormula(cell)
HasFormula = cell.HasFormula
End Function



--ron

Cheers Ron,
Sorted.
I was expecting an 'IS' test (ISDATE, ISERROR etc) not a 'HAS' test.



"Ron Rosenfeld" wrote:

On Thu, 23 Nov 2006 06:45:02 -0800, Gizmo63
wrote:

Quick question.

Is there a VBA command that tests the activecell to see if it contains a
formula as opposed to actual text or number?
I've found tests for errors, dates, numbers, text etc.
You can test for "=" as it tests the value of the cell.

Prob really simple but I'm baffled.

Cheers
Giz


Function HasFormula(cell)
HasFormula = cell.HasFormula
End Function



--ron

On Fri, 24 Nov 2006 04:43:02 -0800, Gizmo63
wrote:

Cheers Ron,
Sorted.
I was expecting an 'IS' test (ISDATE, ISERROR etc) not a 'HAS' test.




Glad to help.
--ron