VBA: Format Painter

September 9th, 2004 | Categories: VBA | Tags:
-->

A simple example of using the Format Painter in a macro. The following code copies the formatting(color, font, etc) from cell A1 and pastes it on cell B1. 

Sub FormatPainter()

    Range("A1").Copy
    Range("B1").PasteSpecial
    Application.CutCopyMode = False

End Sub
Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Leave a comment | Trackback
No comments yet.