Shazam
01-27-2006, 10:55 AM
Hey everyone,
I'm trying to do a fill down effect but doing a paste special format.
With Range("A2:P" & Range("A65536").End(xlUp).Row)
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
Any ideas how to achieve this?
I'm trying to do a fill down effect but doing a paste special format.
With Range("A2:P" & Range("A65536").End(xlUp).Row)
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
Any ideas how to achieve this?