Limit Column Data

[MR3]

currently my code searches selects an entire column(s) for conditional formatting if blank cells are there. For example

Columns("A:F").Select

I don't think this is efficient because my data will most likely never get down to the bottom of the worksheet.

I was thinking something along the lines of

LR = Range("A" & Rows.Count).End(xlUp).Row

 

[VoG]

Then it would be

Range("A1:F" & LR).Select

although you should not need to select that range in order to work with it.

 

[MR3]

Then it would be

Range("A1:F" & LR).Select

although you should not need to select that range in order to work with it.

Do you mean I could just put

Range("A1:F" & LR)

and the code will continue without the .Select?

 

[VoG]

No I didn't mean that. You have to do something with the range. You could select it then operate on the selection but you should be able to work without selecting, for example

Range("A1:F" & LR).Sort ' sort parameters go here