Select a range

[wenhwei17]

Hello all i have a set of data from B8 to the end of cell which is a variable cell.

Selection variable cell macro is
Range(“H8”).End(xldown).offset(2).Select

How do i make it highlight from selection of variable cell to cell B8? Note that there is an empty row in between. Thanks!

 

[maabadi]

Welcome to MrExcel Message Board
Try this:

Sub RngSelect()
Dim L As Long, Lcell As Range
L = Range("H8").End(xlDown).Offset(2)
Range("B8:H" & L + 8).Select
End Sub

 

[Fluff]

If you want to select B8 to last used row in col H try

Sub wenhwei()
   Range("B8", Range("H" & Rows.count).End(xlUp)).Select
End Sub

 

[wenhwei17]

Thanks all!

 

[maabadi]

You're Welcome & thanks for feedback

 

[Fluff]

Glad to help & thanks for the feedback.