I have a a macro that refers to sheet names. Well, I've since changed the names of these sheets, and my macro that referenced those sheets no longer works.
I'm having trouble with the syntax on how to relatively reference these worksheets with their index number. Any help would be greatful.
Here's the code
where "Sales Rep Dashboard" is the 1st sheet and "Rep Account Detail" is the 2nd sheet.
Please Login or Register to view this content.
Again, any help would be greatly appreciated.
Hello adoepker,
You can reference the worksheets by their positional index (the left to right order when viewed) as follows:
Please Login or Register to view this content.
Because these are references are based on the worksheets' physical positions changing the order will cause problems.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
When i try to reference the sheet numbers in the first line of the code, the array that selects two sheets, i get an error. I'm sure it's just a simple syntax error, but i can't get it to work for me. .
This works for me:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
That code works for me too. Thanks!
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks