Range(StartCell, EndCell).Select

ryguy7272 wrote:

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---

--
RyGuy

--

Dave Peterson