Hello,
I have this duplicator code that for some reason the last sheet copied name in the index of the Admin sheet is "CopySheet (2)" but it should be named the last Job.
This is activated on the Admin sheet by first selecting the number of copies then click the shape "Add New Job Sheets".
Can someone please see why?
Thank you for your help
Please Login or Register to view this content.
Code worked fine on my machine.
If I were to guess...
Though highly unlikely, it's ActiveSheet.Name that misfired. As in, it was executed before copied sheet became active.
Or the code terminated right after Sheets().Copy...
But hard to say. May be replace ActiveSheet.Name line to...
Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Thanks but it is still doing the same thing. Did you look at the Admin sheet to see the sheet names? The last one is named 'CopySheet (2)' yet the associated tab has the correct Job name.
I was able to solve issue:
I changed the ListSheets formula to:
=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")&T(NOW())
And put this in This Workbook code:
Please Login or Register to view this content.
Different approach.
Please Login or Register to view this content.
Experience trumps academics every day of the week and twice on Sunday.
Ah so the issue wasn’t the code. I was only looking at the issue in the code.
I wasn't sure where the issue was. I found someone with a similar issue and adapted to my workbook. So far it is working better.
Not entirely sure where your sheet list is but, given you are using VBA anyway, youu could use something like this:
You might not then need to complicate the sheet(s) with Excel 4 Macros. Just a thought.Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Have you tried the code from Post #5 at all?
@jolivanes yes I tried it but it only gives me one copy. I would like it to copy the number of times that are in cell K4 of the Admin sheet please.
Is this solved? If not, please remove the SOLVED tag!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
It is solved but jolivanes asked if I tried his code.
Not very sophisticated but easy to follow and change if required.
Please Login or Register to view this content.
Thank you @jolinvanes.
Your code works great!
Thanks for the update and good luck
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks