Tweak code to copy range formatting too (instead of just copying values)

**Andrew.Trevayne** · 02-04-2017, 01:57 AM

Hi all,
Need some help in tweaking the below codes.
Currently it is only copying the values from my "Data Source" sheeet.
Can you help me modify it so that it copies the formatting as well?

Please Login or Register  to view this content.

I tried the below but no dice.

Please Login or Register  to view this content.

Thank you in advance.

**jindon** · 02-04-2017, 02:04 AM

Perhaps

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**Andrew.Trevayne** · 02-04-2017, 03:01 AM

Originally Posted by jindon

Perhaps

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thank you sir. Working perfectly.

Tweak code to copy range formatting too (instead of just copying values)

LinkBack

Thread Tools

Rate This Thread

Display

Tweak code to copy range formatting too (instead of just copying values)

Re: Tweak code to copy range formatting too (instead of just copying values)

Re: Tweak code to copy range formatting too (instead of just copying values)

Thread Information

Users Browsing this Thread

Similar Threads

Tweak to VBA code for copying from Excel into Powerpoint

[SOLVED] Tweak my code so it does not copy rows that are in the shaded area

[SOLVED] Copy range values without copying the formatting

Code tweak needed: Copy macro not copying formats only values (with getobject)

Copying Values and Formatting without Copy/PasteSpecial

Copy Table Code - Tweak

code tweak to copy data from sheet1 to sheet2

Bookmarks

Bookmarks

Posting Permissions