Retrieve Row Index Number
 

Hello all,

I am writing a macro where I would like to retrieve the row number and
set an integer variable to that value.

For example I have:

Dim RowVal As Integer

If I am in cell M7, how do I get RowVal to be = to 7?

Retrieve Row Index Number
 

RowVal=ActiveCell.Row

loren.pottinger wrote:
Hello all,

I am writing a macro where I would like to retrieve the row number and
set an integer variable to that value.

For example I have:

Dim RowVal As Integer

If I am in cell M7, how do I get RowVal to be = to 7?

Retrieve Row Index Number
 

You have responses at your other posts.

"loren.pottinger" wrote:

Hello all,

I am writing a macro where I would like to retrieve the row number and
set an integer variable to that value.

For example I have:

Dim RowVal As Integer

If I am in cell M7, how do I get RowVal to be = to 7?

--

Dave Peterson