I thought I could use the codename ("sheet1") instead of the actual sheet name ("sales") in VBA so if the sheet name was changed it would not affect the macro. Am I wrong or am I doing something wrong. I have tried it with and without the "" around it. ???? Please help!
Hi, backyardfun,
correct syntax should be
or
Please Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Or you can use the order of the sheet
abousettaPlease Login or Register to view this content.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Hi, abousetta,
just for being curious: what will happen if Sheets(1) is a chart? You should at least recommend to use Worksheets(1).
Ciao,
Holger
Have you ever seen a chart called "Sheet1"? Can't say that I have
Hi, abousetta,
where do you pick up the name of the sheet? You just refer to the very first sheet in the workbook with Sheets(1) regardless of any name - please correct me if I got the fundamentals wrong.
Ciao,
Holger
From the first post...
Originally Posted by backyardfun
It doesn't matter in what order or whatever the name is
Please Login or Register to view this content.
Last edited by HSV; 12-22-2013 at 10:01 AM.
Kind regards, Harry.
I keep getting a run-time error 9, script out of range, and it highlights the first line with the codename ("sheet2") in it. ??????
Please Login or Register to view this content.
Try this.
Please Login or Register to view this content.
If posting code please use code tags, see here.
If you are going to use the codename then it's:
abousettaPlease Login or Register to view this content.
got it. thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks