Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple question- please help! | Excel Discussion (Misc queries) | |||
Simple Question - Please Help! | Charts and Charting in Excel | |||
Very simple question. | Excel Discussion (Misc queries) | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) |