RobRayborn
New Member
- Joined
- Oct 19, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
After downloading the https://www.mrexcel.com/download-center/2017/12/MrExcelWorksheetSplitter.xlsm, link and following the instructions provided the VBA code constantly hangs up on the WS.Copy line of code. If I skip over this line and allow the macro to finish, I end up with on copy of the file with the multiple sheets, that file is named Sheet1 and all the pivot tables are now gone from the new copied sheets.
What am I missing or not understanding. I think I've watched the video 10 times now. I am not a VBA person. That is why I was counting on the MrExcelWorksheetSplitter.xlsm to do the job.
What am I missing or not understanding. I think I've watched the video 10 times now. I am not a VBA person. That is why I was counting on the MrExcelWorksheetSplitter.xlsm to do the job.