Is there a code which can filldown only format of a selection -
something like code below but the format only.


Sub Macro1()

Selection.FillDown
End Sub

Thxs

Hi,
you can try this line of code if u want to fill cells with "format" only.

Selection.AutoFill Destination:=Range("A1:A65536"), Type:=xlFillFormats
Ankit,
India

"al007" wrote in message
oups.com...
Is there a code which can filldown only format of a selection -
something like code below but the format only.


Sub Macro1()

Selection.FillDown
End Sub

Thxs