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?
"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?