Page 2 of 2
Posted: Fri Dec 05, 2003 4:53 am
by Mark Pierson
mr_d_p_gumby wrote:Code: Select all
kmVersion = ThisWorkbook.Worksheets("Setup").Range("KM_Version").Value
Great! Now explain to me how that's causing an error when it's been in the code all along, and I didn't make any changes in that procedure?
I've had this problem before with XL97 masking the real problem. I think I need to track down a PC with it to test myself.
Posted: Fri Dec 05, 2003 8:34 am
by Mark Pierson
I think I found the problem. It seems that some how there's a corrupt piece of VBA code that only shows itself in XL97. When I opened KM in XL97 here at work, I got the error, and found the piece of code. When I went to fix it on my XL2k machine, it wasn't there! I found a way around that, but don't have my latest working version here.
Everyone with the problem can hang tight and I'll hopefully get something uploaded later this evening.