Freezing the data in a column and moving the calculations to the next column
 

I have a simple P&L by month with 12 months along the top.
I'm trying to figure out the VB code that would enable an operator to copy a
selected column - say the january column, copy the formulas only to the
february column and then paste-special-values in the original january
column. This works OK manually except the paste-special-formulas only
command also pastes the previous column headings as well!
Can anyone suggest how to do this?

Freezing the data in a column and moving the calculations to the next column
 

don't copy the whole column, start with the cell below the headers.

--
Regards,
Tom Ogilvy


"Mervyn Thomas" wrote in message
...
I have a simple P&L by month with 12 months along the top.
I'm trying to figure out the VB code that would enable an operator to copy
a
selected column - say the january column, copy the formulas only to the
february column and then paste-special-values in the original january
column. This works OK manually except the paste-special-formulas only
command also pastes the previous column headings as well!
Can anyone suggest how to do this?