handling blanks in a numeric test

[justin]

I have a macro with:
"If ((Rows.Cells(3)) > 10) Then"

and it works fine unless I try it on a spreadsheet with blanks in cell(3). then I get a "runtype error 13 . type mismatch"

How can I check for blanks and get rid of them before they cause this problem?

 

[kmiles]

On 2002-04-05 13:17, justin wrote:
I have a macro with:
"If ((Rows.Cells(3)) > 10) Then"

and it works fine unless I try it on a spreadsheet with blanks in cell(3). then I get a "runtype error 13 . type mismatch"

How can I check for blanks and get rid of them before they cause this problem?

try:
If (isnumeric((Rows.Cells(3))) > 10) Then

 

[kmiles]

Sorry, my mistake, should be:

If (isnumeric(Rows.Cells(3)) then
If ((Rows.Cells(3)) > 10) Then