vzachin
06-10-2008, 01:05 PM
hi,
i have a piece of code that will work on excel2003 but will not work in excel2000 because the feature is not there.
how can i incoporate into the code to check the version of excel running?
if excel2003 then
Worksheets("sheet1").tab.ColorIndex = 5
end if
when i write code using excel2003, is there any (aside from running the code in an older version) to know that the code will fail?
thanks
zach
i have a piece of code that will work on excel2003 but will not work in excel2000 because the feature is not there.
how can i incoporate into the code to check the version of excel running?
if excel2003 then
Worksheets("sheet1").tab.ColorIndex = 5
end if
when i write code using excel2003, is there any (aside from running the code in an older version) to know that the code will fail?
thanks
zach