E
Eva Shanley
Hello,
I have a macro that hides some columns based on a
selection from a validation list. The original
spreadsheet was developed in Excel XP; I created the code
in Excel 2000 because at the time I didn't realize the
programmer had done the spreadsheet in XP. I ran and
checked the macro which was not working, but I did not get
an error in XP. I switched over to 2000, ran the macro,
got an error, and because of the error message then
figured out what was wrong with it. My point to this
whole rambling explanation is, does anyone know why I
would not get the error in XP? The error was a "subscipt
out of range" because I'd referred to an array of sheets
and some of them had been deleted. Unless I had checked
to see if the columns were hidden I wouldn't have known
the macro didn't work. Thanks!
I have a macro that hides some columns based on a
selection from a validation list. The original
spreadsheet was developed in Excel XP; I created the code
in Excel 2000 because at the time I didn't realize the
programmer had done the spreadsheet in XP. I ran and
checked the macro which was not working, but I did not get
an error in XP. I switched over to 2000, ran the macro,
got an error, and because of the error message then
figured out what was wrong with it. My point to this
whole rambling explanation is, does anyone know why I
would not get the error in XP? The error was a "subscipt
out of range" because I'd referred to an array of sheets
and some of them had been deleted. Unless I had checked
to see if the columns were hidden I wouldn't have known
the macro didn't work. Thanks!