handling blanks in a numeric test

justin · Apr 5th, 2002, 02:17 PM

I have a macro with:
"If ((Rows(y).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 · Apr 5th, 2002, 02:49 PM

Quote:

On 2002-04-05 13:17, justin wrote:
I have a macro with:
"If ((Rows(y).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(y).Cells(3))) > 10) Then

kmiles · Apr 5th, 2002, 03:14 PM

Sorry, my mistake, should be:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 02:17 PM	#1
justin New Member Join Date: Apr 2002 Posts: 5	I have a macro with: "If ((Rows(y).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?

Apr 5th, 2002, 03:14 PM	#3
kmiles Board Regular Join Date: Apr 2002 Posts: 113	Sorry, my mistake, should be: If (isnumeric(Rows(y).Cells(3)) then If ((Rows(y).Cells(3)) > 10) Then