PDA

View Full Version : Solved: cell formatting row wise



ilyaskazi
05-26-2005, 11:59 PM
In my activesheet do cell formatting row wise...

1) Select first row, fill grey color

2) Select second row, fill light green color

3) Select third row, fill grey color

4) Select forth row, fill light green color

and like wise to all rows upto data is found in its last rows.

mdmackillop
05-27-2005, 12:44 AM
Unless you really need code, or you have other unwanted formatting, colour the first two rows manually, select the first two rows, click on FormatPainter and drag down with the fill button.

ilyaskazi
05-27-2005, 01:35 AM
No, i require through vba only to apply until last row of data is found of column A

ilyaskazi
05-27-2005, 02:35 AM
anyways, i hv solved myself.

thanku for guiding. It helps to write code.