The VBA Editor has the annoying habit of keeping variable names in
its mind even after you've deleted the declarations for those
variables. For example, if you define a module level named
'SELECTION' then delete that variable declaration, VBE will
continue to use 'SELECTION' rather than 'Selection'. It is a bug
in VBE.

You probably declared a variable at some point named 'SELECTION'
and then deleted that declaration. Try declaring a module level
name 'Selection' then deleting the declaration. This should set
VBE back on the right path.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"bwilcox" wrote in message
...
In a single Excel VBA project, the typed word "Selection"
now automatically becomes "SELECTION" rather than
remain "Selection". What did I inadvertently change?