Copying Cell Formats

pakman · October 18th, 2004, 06:15 AM

Is there a quick means in VBA to copy a range of cells from one sheet to another including all of its formatting properties such as colour, font, borders?

Birger · October 18th, 2004, 08:25 AM

Try this:

    Selection.Copy
    Sheets("Sheet2").Select
    Range("A1").Select
    ActiveSheet.Paste

..or use the MacroRecorder in the Functions Menu to get the code.

pakman · October 18th, 2004, 11:13 AM

Thank you.

For some reason I thought this would only copy the value, but I see it copies the format as well.

Birger · October 18th, 2004, 11:23 AM

You're welcome!

I guess you was thinking of 'Paste Special' from the Edit menu where you can de-/select different formats.