- 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
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: