LinkBack URL
About LinkBacks
Declare in by index number.
You can find this info by selecting the sheet and running
Sheets(3).Activatemsgbox activesheet.index
e/ Note - this will only work if the name of the sheet changes but its position in the workbook does not.
Declare in by index number.
You can find this info by selecting the sheet and runningSheets(3).Activatemsgbox activesheet.index
e/ Note - this will only work if the name of the sheet changes but its position in the workbook does not.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks