Hello,
I would like to extend down (until last filled cell) the formatting of range A2:C2. When I record macro I have the following:
What would be the best way to do it without using a Select statement?
I would like to extend down (until last filled cell) the formatting of range A2:C2. When I record macro I have the following:
Code:
Range("A2:C2").Select
Selection.Copy
Range(Selection, Selection.End(xlDown)).Select
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range(Selection, Selection.End(xlDown)).Select
What would be the best way to do it without using a Select statement?