VBA Select Active Cells in Column

[jerryneubauer]

I have a report that has a variable number of rows, depending on the number of transactions returned.

I need to select the active cells in Col. "L", but exclude the last active cell, because it contains the Total for that column.

The data to select in column "L" starts on row 5.

Once I get this line of code, I can apply some Conditional formatting.

Thanks to all.

 

[Caleeco]

Hello

This line of code will select the range you require, as long as there isnt further data below the total of the column:

Sub SelectRange()

ActiveSheet.Range("L5:L" & Range("L" & Rows.Count).End(xlUp).Row - 1).Select


End Sub

Caleeco

 

[jerryneubauer]

Thanks!

 

[Caleeco]

No Problem :wink: