Retrieve Row index number

[loren.pottinger]

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?

 

[Guest]

use this one:
RowVal = ActiveCell.Row

pls do rating

 

[Bernard Liengme]

Use form:
RowVal = ActiveCell.Row
best wishes

 

[loren.pottinger]

Thanks worked great. Please watch this post, I may have another
question in a bit, my macro still isn't doing what I want it to do.

 

[Dave Peterson]

You have responses at your other posts.

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?

 

[loren.pottinger]

Thank you all for the help.

You have responses at your other posts.

 

[Dave Peterson]

You seem to post the same question to lots of newsgroups. By doing this, you
waste the time of people who answer in each of the other newsgroups.

And you waste your time by having to check in each of those groups.

And worse yet, you may find that others read your name and assume that you have
a response elsewhere and won't take the time to respond.

Chip Pearson has some nice notes that you may want to review:
http://www.cpearson.com/excel/newposte.htm