Posted to microsoft.public.excel.programming

external usenet poster

Posts: 3

Macro to create format painter

I am trying to create a macro that when I press Ctrl+m, it would be as if I
am pressing the format painter icon. I tried recording a macro and each
time I press ctrl+m, it copies the cell, but not the format. Could someone
tell me how to create the macro to copy the format only of a cell?

Thanks Again as I am a newbie when it comes to macros/vba

JD

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

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

All times are GMT +1. The time now is 12:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us