Thread: Last cell in a range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
gocush[_9_] gocush[_9_] is offline
external usenet poster
  
Posts: 1
Default Last cell in a range

Try:

Dim Bal
Bal = ActiveCell.End(xlToRight)

then if you want to proceed to the next row use

Activecell.Offset(1,0).Activate


This can also be put in a loop to cycle thru the list and get the las
cell of each row.


Note: the Offset(0,0) does NOTHING - It just means do not offset an
rows or colums

HT

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Reply With QuoteReply With Quote