Simple Question
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? |
All times are GMT +1. The time now is 01:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com