Error Checking Option

M

mangesh_yadav

The new versions of Excel support error checking options while the ol
ones do not. Through VBA code I automatically set these options, bu
when I use this file in an older version, I get an error: 438: Objec
doesn't support this property or method. And my code fails at thi
point in the older versions of excel. How do I check whether th
property exists and then only accordingly set it?

Manges
 
T

Tom Ogilvy

The best you could do is check the version and then only branch to access
code compatible with that version. If the difference is specific to VBA5
vice VBA6, you can do conditional compilation, but it doesn't sound like
this is the situation. Another approach is not to use the new arguments at
all. Code for the lowest version where the code must run.
 
M

mangesh_yadav

Well, this is what I did: I just use Resume Err_Handler so that when a
error comes the entire step is by-passed.

Manges
 
Top