Hello all,
I have a macro that saves me my excel workbook, in a specific location, with a name from a specific cell.
The problems i have right now is this:
- i don't want the macro to save the entire sheet 1, only A1:V100
This is the code i have right now:
Please Login or Register to view this content.
Thank you!
Last edited by julius2017; 10-26-2017 at 04:22 AM.
Done!
Sorry about that, Ali!
Best regards
Please help !
Last edited by julius2017; 10-26-2017 at 04:21 AM.
Please see edited original post.
How about this ?
Please Login or Register to view this content.
Last edited by bakerman2; 10-26-2017 at 06:48 AM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thank you for your ansewer, bakerman.
Your code gives me an error on this line:
ThisWorkbook.Sheets("Delivery").Range("A1:V100").Copy NewBook.Sheets(1).Range("A1")
Last edited by julius2017; 10-26-2017 at 07:53 AM.
That line doesn't exist in the code posted ...
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.
I changed the name of the sheet, to what i need. Post correct now.
And it seems that everything is fine... Bakerman's VBa it's working ok.
Is there any change i could keep the original formating and paste everything as values?
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks