Capturing Row Number

[boylejob]

I know I have seen the answer to this question on this list before, but I am unable to find it now.

I have a sub that searches a spreadsheet for information. When it finds the information it uses some offset statements to grab various data. What is the code that can be used to capture what row you are on.

Thanks!

[jasoncw]

Just use .Row after the range. For example:

ActiveCell.Row

' OR

Range("A65536").End(xlUp).Row

etc.

[miked342]

I use -

MyRow = ActiveCell.Row: MyCol = ActiveCell.Column

to capture my location and then use -

Cells(MyRow, MyCol).Select

to re-position the cursor.

You can position the cursor to anywhere you want by -

ActiveCell.Offset(0, 4).Value

Which means - move 4 cells to right on same row.

ActiveCellOffset(2,-3).Value

Move cursor from present position to 3 Cells left, and down 2 Cells.