Thread: last cell in range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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
Reply With QuoteReply With Quote