Shoot I got as far as Tools, macro, record new macro...then duhhhh...
Sorry, I am a confirmed imbicile!

Chuch... a few more steps budz.....

Mark

"CLR" wrote:

Doing Tools Macro Record new macro......and then following the steps of
manually inserting a new column to the left of column M and then Copy
Pastespecial Values L4:L100 over to the new M4:M100. During the setup of
recording the macro the pop-up gives you the opportunity to assign your new
macro to a Ctrl-letter, which would in effect become your hot-key to fire the
macro on demand.

Vaya con Dios,
Chuck, CABGx3



"Mark" wrote:

eI need to use the Numbers presntly in L column.
Since there is a formula in L, I need to copy PASTE SPECIAL VALUE L4:L100
to M4:100.

Is there a way to "automatically insert a column left of M, and copy PASTE
SPECIAL VALUE L4:L100 to M4:100."

Could this be a Hotkey?
I do not see how code could do it, unless it refers to a hot key.

Thanks,
Mark