This should be easy but I can't seem to work it out. I have a worksheet, and want to copy (Range A1:O300) to a NEW Workbook and PASTESPECIAL Values and Formats
Google and YouTube are just not delivering anything this simple. I want the VBA Code to do this.
Hope someone can help
Last edited by SimonCampbell; 10-19-2021 at 06:48 AM.
Not sure how you are searching, but have a look at the two tutorials below:
https://www.excelcampus.com/vba/copy...ther-workbook/
https://excelchamps.com/vba/copy-cell-to-new-worksheet/
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Yes I've seen these, BUT seeing as my project will be used on a number of different platforms amongst other TEAMS, I didn't want the NEW workbook to be saved with a name or location, I just want it to open and paste the data into it, giving the user option to save it to where he /she wants. The Code I am using now is
Please Login or Register to view this content.
Last edited by SimonCampbell; 10-19-2021 at 06:42 AM.
OK - your thread title ought to reflect this as it's a pretty significant caveat and you didn't even mention it in your first post!
Update the title in your first post to this thread, please.
ooopss! wasn't aware it was such a significant caveat. Getting up the learning curve
Copy, create and paste.
Please Login or Register to view this content.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks