I created an Excel macro that changes the color of a range of multiple cells (“Range(“”).Interior.ColorIndex = 3″). The macro was created using Excel 2000 and was transfered to a machine running Office 97. Now when I run the macro an error comes up saying “unable to change the color index of the interior class”. But when I select the range first in the macro code it works. (range.select, selection.interior…). I dont want to do this because it makes my code slow and causes the screen to blip. The macro works fine as is on my Office 2000 machine. Any ideas?
