i've got this strange thing going on...
any help would be appreciated.
i have this small code:
when running this code on Excel with Microsoft Visual Basic version 6.0, it works like a charm and catches the "type mismatch" error i get on
this line
"If IsNumeric(Range(n.Name).Value) And Range(n.Name).Value <> "" Then"
but when running this code on Excell with MVB version 6.3, it does not catch the error at all but just gives me the "type mismatch" error again!
the reason for the "type mismatch" is that it fails over Range(n.Name) where my n.Name refers to a "Print_area"
someone please help me?
Bookmarks