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.


--
Kaibutsu
------------------------------------------------------------------------
Kaibutsu's Profile: http://www.excelforum.com/member.php...o&userid=26168
View this thread: http://www.excelforum.com/showthread...hreadid=394867

cell color adjustment using vba
 

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" wrote in
message ...

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