ExcelBanter - Highlight all cells, except top row?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Highlight all cells, except top row? (https://www.excelbanter.com/excel-programming/278745-highlight-all-cells-except-top-row.html)

Reedi

Highlight all cells, except top row?

Hi,

Is there a way to hightlight all cells in a worksheet except for the top row
(row 1)?

Thanks in advance,

Reedi

Ron de Bruin

Highlight all cells, except top row?

Try

Rows("2:65536").Select

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl

"Reedi" wrote in message ...
Hi,

Is there a way to hightlight all cells in a worksheet except for the top row
(row 1)?

Thanks in advance,

Reedi

All times are GMT +1. The time now is 11:43 PM.