Is there a best practice with regard to how a worksheet is referenced?
I'm thinking of Sheets(n) vs "Sheetn" (the text on the sheet tab)
Is there a best practice with regard to how a worksheet is referenced?
I'm thinking of Sheets(n) vs "Sheetn" (the text on the sheet tab)
Name them something short yet meaningful.
If you mean in code within the same workbook, then use the codename if possible as it is much less likely to be changed by a user than the tab name or position.
Rory
You can find the Sheet CodeName by opening the Project Explorer(ALT-F11) and in the Left Pane look for the Name NOT between parenthesis.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks