Dan Wilson
Well-known Member
- Joined
- Feb 5, 2006
- Messages
- 507
- Office Version
- 365
- Platform
- Windows
Good day. I am running Office 365 (updated) on Windows 10 Home. I have a workbook with a macro to create a new worksheet in the same workbook loaded with data accessed from another workbook. When all is done, I would like to rename the new worksheet as "DB". I know how to do it after the process is complete, but each time the process runs it creates a new worksheet number. Is there a macro statement to rename the selected worksheet no matter what number it was created as? Thank you for any help.
Dan Wilson...
Dan Wilson...