Hello,
I am getting a subscript out of range error when trying to create a workbook copy. I don't understand why this isn't working. It seems pretty legit to me.
Please Login or Register to view this content.
Hello,
I am getting a subscript out of range error when trying to create a workbook copy. I don't understand why this isn't working. It seems pretty legit to me.
Please Login or Register to view this content.
Maybe
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
The short answer is
Also there may be other problems with how Item is being used; I have not used Item for the Worksheets collection. If you have other problems try this:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by 6StringJazzer; 03-25-2019 at 03:04 PM.
Thank you both. I tried both methods, but both throw errors.
mehmetcik - method/data member not found on .Sheets
Jeff - method/data member not found on .WorkSheets.Count
I know it's generally frowned upon, but if I have On Error Resume Next initially, it works. The workbook is created, all sheets copied over, files saves and closes. I don't like that I have to put that in there, but if it works, it works I guess..unless you can see more clarity with the preceding thrown errors.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks