About Us

PSKelligan

Hi JD,
I recorded this and if you copy (ctrl+c) and use this code, it will paste
the formatting only to the active range of cells. To get the ctrl+m added
just record a macro in your personal macro workbook and set the shortcut key
to ctrl+m and then paste the body of my code to the macro.

Code:

Sub PasteFormating()
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
    Application.CutCopyMode = False
End Sub

Hope this helps,

Patrick

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Format painter	maltagirl	Excel Worksheet Functions	0	September 7th 09 06:56 PM
copy conditional format without using format painter	MsConfused	Excel Worksheet Functions	2	May 4th 09 07:16 AM
Format Painter	Fay	Excel Discussion (Misc queries)	1	March 14th 08 07:44 PM
how can I use the format painter??	hermosilla	New Users to Excel	1	August 11th 06 11:56 PM
format painter	gregork	Excel Programming	2	February 11th 04 09:58 AM

Menu

About Us