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
 

use this one:
RowVal = ActiveCell.Row

pls do rating

"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
 

Use form:
RowVal = ActiveCell.Row
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"loren.pottinger" wrote in message
ps.com...
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
 

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.

Muhammed Rafeek M wrote:
use this one:
RowVal = ActiveCell.Row

pls do rating

"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

Retrieve Row index number
 

Thank you all for the help.

Dave Peterson wrote:
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

Retrieve Row index number
 

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



"loren.pottinger" wrote:

Thank you all for the help.

Dave Peterson wrote:
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

--

Dave Peterson