VBA doesn't recognise "selection"

[cmhoz]

Hi All - I'm having a bizare problem in VBA.

I have a report that has been running in it's current state for several months with no issue. However, today it has decided that it doesn't understand the word 'selection'.

eg: selection.copy gives compile error.

Now... obviously NOT USING selection is preferred. However, let's put that aside for now because there are LOTS of these in this report and it's never had an issue until today.

Is there some setting that could have gotten changed or something?

It's happening on multiple computers and we're running Excel 2003 (standard) with SP3.

Thanks!!

 

[ajetrumpet]

if you are on a network, corruption is a very good possibility.