Retrieve Row index number

  • Thread starter Thread starter loren.pottinger
  • Start date Start date
L

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?
 
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.
 
You have responses at your other posts.

loren.pottinger said:
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?
Click to expand...
 
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
 
Back
Top