ExcelBanter - last cell in range

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - last cell in range (https://www.excelbanter.com/excel-programming/381895-last-cell-range.html)

Shlomit

last cell in range

Hi,

I have range (ActiveCell.CurrentRegion) and I want to know the last cell in
the range.
I know that vba has this property but i don't remember it.
Anyone know?

Thanks,
Shlomit

Gary''s Student

last cell in range

ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell)
--
Gary''s Student
gsnu200702

"Shlomit" wrote:

Hi,

I have range (ActiveCell.CurrentRegion) and I want to know the last cell in
the range.
I know that vba has this property but i don't remember it.
Anyone know?

Thanks,
Shlomit

All times are GMT +1. The time now is 07:07 AM.