cell color adjustment using vba

My dear!
There are 12 columns(months). 50 rows each column.
Each is marked by its own color. SAy cell G5 data ( in January) is marked green and i need to transfer cell data to H5 (Feb)blue.
I need the cell color(green) be changed for (blue) automatically. So at the whole table.

How can i do it using VBA ? Or something else. Help me please.
Serge.

Is it as simple as?

For Each cell In Range("G5:G54")
cell.Offset(0,1).value = cell.value
cell.Offset(0,1).interior.Colorindex = 5
Next cell

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kaibutsu" <[email protected]> wrote in
message news:[email protected]...
>
> My dear!
> There are 12 columns(months). 50 rows each column.
> Each is marked by its own color. SAy cell G5 data ( in January) is
> marked green and i need to transfer cell data to H5 (Feb)blue.
> I need the cell color(green) be changed for (blue) automatically. So
> at the whole table.
>
> How can i do it using VBA ? Or something else. Help me please.
> Serge.
>
>
> --
> Kaibutsu
> ------------------------------------------------------------------------
> Kaibutsu's Profile:
http://www.excelforum.com/member.php...o&userid=26168
> View this thread: http://www.excelforum.com/showthread...hreadid=394867
>