LinkBack URL
About LinkBacks
Hi,
I am working with the following part of code;
Please Login or Register to view this content.
What would i replace "My New Worksheet" with to get the current worksheet name (see array above) plus the word "Budget"?
Thanks
Hi,
I am working with the following part of code;
Please Login or Register to view this content.
What would i replace "My New Worksheet" with to get the current worksheet name (see array above) plus the word "Budget"?
Thanks
Try this -
Please Login or Register to view this content.
Maybe:
Please Login or Register to view this content.
Reagan.kha,
Thank you for your response, your solution may have worked but John's made more sense to me so I went with that one.
John,
Thanks for your help. If you have a spare moment can you review my code and tell me why it stops after the first worksheet in my array? After running the code it creates a new sheet and names it "Mach-1 Budget" and then nothing else happens. Also the code only works if I run the macro from the sheet named "Mach-1". What am I doing wrong?
ThanksPlease Login or Register to view this content.
Last edited by MICowboy13; 06-12-2015 at 03:45 PM.
From what I see Mach should be declared as a worksheet. And Machs should be a Sheets Array. I don't have much time as I'm signing off for the weekend. If you haven't got a solution by Monday, I'll be glad too revisit.
John,
Thanks for your help and have a great weekend.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks