Set StartRange and End Range

[ryguy7272]

I am trying to get Excel to select all the cells between Cell A3 and the last
used cell in Column A.

Code below:
Dim StartCell, EndCell As Range
Set StartCell = Range("A3")
Set EndCell = Cells(Rows.Count, "A").End(xlUp)
Range("StartCell:EndCell").Select

What am I doing wrong?

Thanks,
Ryan---

 

[Gary''s Student]

Sub zeroo()
n = Cells(Rows.Count, "A").End(xlUp).Row
Range("A3:A" & n).Select
End Sub

 

[Dave Peterson]

Range(StartCell, EndCell).Select

I am trying to get Excel to select all the cells between Cell A3 and the last
used cell in Column A.

Code below:
Dim StartCell, EndCell As Range
Set StartCell = Range("A3")
Set EndCell = Cells(Rows.Count, "A").End(xlUp)
Range("StartCell:EndCell").Select

What am I doing wrong?

Thanks,
Ryan---

 

[ryguy7272]

The logic is sound for both subs!!
Thanks GS and thanks DP!!!!
Ryan---