Thread: Incrementing row number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carim[_7_] Carim[_7_] is offline
external usenet poster
  
Posts: 1
Default Incrementing row number

Hi Denis,

Your two questions are very related ...
ActiveCell.Row would give you the row number of the active cell
and
ActiveCell.Offset(1,0) does increment the row by 1 and the column by 0
....

HTH
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=531295

Reply With QuoteReply With Quote