View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default Incrementing row number

maybe something like this

Option Explicit
Dim rNum As Long
Sub next_row()
rNum = ActiveCell.Row + 1
Debug.Print rNum
End Sub

--


Gary


"den1s" wrote in message
oups.com...
Is there a command that simply increments the row number?

I know you can use the command cells(x,x) to select the specific cell
but I would like to increment the row number, without prior knowledge
of where I was.

Also is there a command that returns the current active cell?

- D