if col g becomes the values of col f, how does now col h become the value
for col g??

--
Don Guillett
SalesAid Software

"Brian" wrote in message
...
I am using the following code in a macro and the purpose is to have cells
in
a column take on the value of the cells in the column beside it...

Private sub
range ("i7:i600").value=Range("h7:h600").value
range ("h7:h600").value=Range("g7:g600").value
range ("g7:g600").value=Range("f7:f600").value
end sub

I want to expand the above macro to do approximately 100 additional
columns.
Do I have to write out each line individually or is there a shorter code
that
will do this.

Thanks.