row number

G

Guest

Guest
Hello people
Do you know what's the syntex to return the row number of the selected cell in excel by using VB ?
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
How's this:

Sub rowNum()
ActiveCell = ActiveCell.Row
End Sub

Cheers, Nate
 
Upvote 0
One more question
what should I put if I need the row number of a cell which is NOT SELECTED?
 
Upvote 0
You mean like a test? You could do something like the following:

Sub rowNum()
myRange = ActiveCell.Row
If myRange<> 2 Then 'row 2 for expample
MsgBox ("Smarten' Up") 'Procedure if True
Else: MsgBox ("Well Done") 'Procedure if False
End If
End Sub

HTH. Cheers, Nate
This message was edited by NateO on 2002-03-04 11:09
 
Upvote 0

Forum statistics

Threads
1,213,491
Messages
6,113,963
Members
448,536
Latest member
CantExcel123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top