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
|