How to change the color of a row using VBA
 

Hi, thanks for the other help, know I need to see if I can
change the color of a hole row using Excel VBA. I've been
trying to work around the code but it gives me an "Object
Required" Error. thanks in advanced

How to change the color of a row using VBA
 

Hi

This will color the activecell row

Sub test()
Rows(ActiveCell.Row).Interior.ColorIndex = 3
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"George" wrote in message ...
Hi, thanks for the other help, know I need to see if I can
change the color of a hole row using Excel VBA. I've been
trying to work around the code but it gives me an "Object
Required" Error. thanks in advanced

How to change the color of a row using VBA
 

Range("A1").Entirerow.Interior.ColorIndex = 3

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"George" wrote in message
...
Hi, thanks for the other help, know I need to see if I can
change the color of a hole row using Excel VBA. I've been
trying to work around the code but it gives me an "Object
Required" Error. thanks in advanced