I have this macro to copy the values from one workbook to another, but I also would like the formats to be copied as well. Any help is greatly appreciated.
Please Login or Register to view this content.
I have this macro to copy the values from one workbook to another, but I also would like the formats to be copied as well. Any help is greatly appreciated.
Please Login or Register to view this content.
I think you'd need to copy the source range and then Paste Special the values AND the formats.
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
Yeah thats what Im trying to do and I have something wrong here. I keep getting a 1004 error if I try to do it that way. The macro above works fine, just cant get it to work for the formats. Is there a better way to do this than what I have?
Thiswould need to change toPlease Login or Register to view this content.
Please Login or Register to view this content.
Thank you. This doesnt error out anymore, but it doesn't actually copy and paste the formats. There is no change in the result with the macro that I originally had and what you've changed.
I just separated the macros with one copying the values and one copying the formats while having one called after the other and it works fine. I'll mark as solved, thanks!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks