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