View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Mark is offline
external usenet poster
 
Posts: 989
Default Is this possible with Excel

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