Hi,
Can I get to the "last cell" using vbscript or other "com" using equivalent of

Selection.SpecialCells(xlCellTypeLastCell).Select

the com doesn't like the parameter "xlCellTypeLastCell".
Best, randall

Hi randallc

Use Rows.Count.End(xlUp)
--
ve_2nd_at. Randburg, Gauteng, South Africa


"randallc" wrote:

Hi,
Can I get to the "last cell" using vbscript or other "com" using equivalent of

Selection.SpecialCells(xlCellTypeLastCell).Select

the com doesn't like the parameter "xlCellTypeLastCell".
Best, randall

Hi Kassie,

Will your instruction work? As far as I know Rows.Count returns a number not
range.

To find the last cell in a coulumn you could use:

Cells(Rows.Count, "A").End(xlUp).Select

To find the last cell in a sheet you could use:

On Error Resume Next
Intersect( _
Cells.Find("*", Cells(1), xlValues, xlWhole, xlByRows, _
xlPrevious).EntireRow, _
Cells.Find("*", Cells(1), xlValues, xlWhole, xlByColumns, _
xlPrevious).EntireColumn).Select

Regards,
KL

"Kassie" wrote in message
...
Hi randallc

Use Rows.Count.End(xlUp)
--
ve_2nd_at. Randburg, Gauteng, South Africa


"randallc" wrote:

Hi,
Can I get to the "last cell" using vbscript or other "com" using
equivalent of

Selection.SpecialCells(xlCellTypeLastCell).Select

the com doesn't like the parameter "xlCellTypeLastCell".
Best, randall