Highlighting a specific block of cells using VBA

[Mr2017]

Hi

I want to highlight a specific block of cells in a spreadsheet.

I know this code highlights the block of cells going from A3 until the bottom of the range and to the right of the range (with data in it).

However, how should I modify it if I have a sheet with data in columns A to Z, but I only want to highlight the data in columns A to O, for example?


Range(“A3”,Range(“A1”).End(xlDown).End(xlToRight)).Select

Thanks in advance!

 

[Rick Rothstein]

Hi

I want to highlight a specific block of cells in a spreadsheet.

I know this code highlights the block of cells going from A3 until the bottom of the range and to the right of the range (with data in it).

However, how should I modify it if I have a sheet with data in columns A to Z, but I only want to highlight the data in columns A to O, for example?

Range(“A3”,Range(“A1”).End(xlDown).End(xlToRight)).Select

I would think this should work...

Intersect(Columns("A:O"), ActiveSheet.UsedRange).Select

 

[Mr2017]

Ok, thanks Rick.