select last cell in used range

  • Thread starter Thread starter Tony P
  • Start date Start date
T

Tony P

Hi all,

How do I select the last (right, bottom) cell in a used
range.

Have played with the Range(ActiveSheet.UsedRange.Cells
(?).Address).Select - with no luck.

Any help would be appreciated.

Tony.
 
Hi Tony,

Short snippet example:
Dim lastcell As Range
Set lastcell = Cells.SpecialCells(xlLastCell)
lastcell.EntireRow.Select

The following single line of code should do what you asked:

cells.specialcells(xlLastCell).activate

--
 
Back
Top