| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
| Conditional format color is set correct, yet color will not change | Excel Worksheet Functions | |||
| Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
| how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Linear Mode
