VBA - how to expand range to include blank cells?

[kgkev]

I would normally use.

OS.Range("A3", OS.Range("K56000").End(xlUp))

To select my range - However on this occasion there is a good chance K will be blank.

I am 100% certain "B" will be filled to the bottom.

How do I expand from this to have the range

A3:K?? filled to the lowest point of data in "B"

Thanks

 

[VoG]

Try like this

LR = Range("B" & Rows.Count).End(xlUp).Row
Set rng = Range("A3:K" & LR)