LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 336
Default naming range moves me to macro

If I try to give a range the same name as one of my macros from the name box
(at the top left of the workbook) I find I'm suddenly looking at that macro
with my cursor flashing in the VB editor.

Is there any way to stop this or at least capture it as it will confuse
users? Strangely I don't get the same problem if naming from Insert, Name,
Define.

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Naming a range during macro execution Kevryl Excel Discussion (Misc queries) 2 December 11th 06 10:08 AM
Macro moves data and more!!! Sandeman[_10_] Excel Programming 2 March 21st 06 03:51 PM
range moves with application caller ME @ Home Excel Discussion (Misc queries) 1 February 20th 06 02:22 PM
Macro problems with range and naming issues Vapanda[_3_] Excel Programming 1 June 2nd 04 01:26 AM
Macro That Moves Cursor Down job1job1 Excel Programming 3 February 16th 04 09:44 PM


All times are GMT +1. The time now is 07:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"