Excel Excel VB - Copy only the colour format from columns

Joined
Oct 17, 2007
Messages
2
Reaction score
0
I want to copy only the colour not the contents with no boarders. I search the xlPasteType and this option is not listed.

My current code is below, help?

Sub CopyColourFormat()
Range("C14:C149").Select
Selection.Copy
Range("X14:X149").Select
Selection.PasteSpecial Paste:=xlAllExceptBorders, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False

End Sub
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top