Is there a way of programming a macro to save sheet with multiple cell values?
I have this set up so far:
If possible, I only want save the selected sheet and to include C2 and D2 in the saved file name.
Please Login or Register to view this content.
Hi joherszch
Perhaps:
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Try this to save the active sheet as a new file:
Please Login or Register to view this content.
Last edited by kev_; 04-05-2017 at 07:20 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Thank you very much! Almost what I wanted, but I was just a bit quick when I wrote "save the selected sheet", I want to save the sheet next to it called PadPilot.
amend one line
Please Login or Register to view this content.
Thank you very much! I got it sorted with that line!
Last edited by joherszch; 04-05-2017 at 09:32 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks