Hi, I am writing a macro saved in a workbook. The problem is the macro contains the worksheet name I created the macro on, but the next person who uses this macro may name the worksheet something else when the new report is copied into the workbook. What can I put here in the worksheet name that will just allow this macro to run regardless of what the sheet is named? Like a generic name? As you can see below, this tab was called "Inventory Valuation Sep 202 (2)" but next time the report is copied over it may be called something else and then this macro won't work. Thank you!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Removing worksheet name in VBA so macro will work on any worksheet?
- Thread starter Chialiwa
- Start date
Michael M
Well-known Member
- Joined
- Oct 27, 2005
- Messages
- 21,835
- Office Version
- 365
- 2019
- 2013
- 2007
- Platform
- Windows
Change the name to "ActiveSheet" without the inverted commas
AND you don't need the Activeworkbook
VBA Code:
Activeworkbook.ActiveSheet.Sort...
VBA Code:
ActiveSheet.Sort...
Upvote
0
Solution
AHHHHHH IT WORKED!!!!! Thank you so much!!!!!!!
Upvote
0
Similar threads
- Solved
- Question
