Format Painter in VBA?

  • Thread starter Thread starter Angelus
  • Start date Start date
A

Angelus

Is there a way to use the format painter in VBA? I mean, basically
copying all the formatting properties of one cell into another cell?

Thank you in advance!
 
maybe something like this

Sub test()
Worksheets("sheet1").Range("b3").Copy
Worksheets("sheet2").Range("g1:g5").PasteSpecial xlFormats
End Sub
 
Back
Top