vba syntax help

[daw60]

The following code gives me an error of Block Variable not set but I don't recognize the problem.
Any help would be appreciated


Sub my_range()

Dim my_range As Range
Dim Last_row As Long

Last_row = Sheets("DATA").Range("B" & Rows.Count).End(xlUp).Row
my_range = Sheets("DATA").Range("B5" & ":F" & Last_row)
Range(my_range).Select

End Sub

 

[MARK858]

Try...

Dim my_range As Range
Dim Last_row As Long

Last_row = Sheets("DATA").Range("B" & Rows.Count).End(xlUp).Row
Set my_range = Sheets("DATA").Range("B5" & ":F" & Last_row)
my_range.Select

 

[daw60]

Try...

Dim my_range As Range
Dim Last_row As Long

Last_row = Sheets("DATA").Range("B" & Rows.Count).End(xlUp).Row
Set my_range = Sheets("DATA").Range("B5" & ":F" & Last_row)
my_range.Select

Thank you for the help Mark... I have a long way to go before I will get the syntax nuances..

 

[MARK858]

You're welcome

I have a long way to go before I will get the syntax nuances..

A Range is an Object so it needs Set in front of it, Text or numbers aren't objects (as in Last_row) and so don't need the Set word.

You are creating my_range as a Range variable and so because it is already a range you don't need to wrap it in Range()