I have data in column one rows 3 thru 9
I am on row 3 and I want to stop at row 6
I have a macro as follows:
dim r as integer
do while r <> 3
activecell.next(2,0).select
r=Row(activecell)
loop
The point here is that I am unsure of my r=Row(activecell)
I thought that there was a function that would return the integer
value of the row of the active cell, but I could not find it.
Does anybody know how to return the row number?
Thanks in advance
I am on row 3 and I want to stop at row 6
I have a macro as follows:
dim r as integer
do while r <> 3
activecell.next(2,0).select
r=Row(activecell)
loop
The point here is that I am unsure of my r=Row(activecell)
I thought that there was a function that would return the integer
value of the row of the active cell, but I could not find it.
Does anybody know how to return the row number?
Thanks in advance