Can anyone advise why when I click on the macros button that the name of the first macro in the list becomes the active cell?
In other words, my first macro in the list is Add204. When I click the macros button, cell "ADD204" will activate on the active sheet. Very annoying.
Excel 2010
Windows 7
Because ADD204 is a cell in Excel 2007->, so it jumps to it. You should never use a cell refernce as a defined name or a macro, use Add_204 or such.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I did rename it to that. I was just curious. Seems to me that shouldn't happen.
thanks
gary
Excel requires the User to be a little disciplined in how they intend to use the program whether at the Object level or within the programming level. Just like A1 is a cell reference so too is ADD204, so as Bob kindly suggested simply use an underscore to differentiate the Macro name from any potential cell reference.Originally Posted by zoom38
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Posting Permissions
Reply With Quote
