row number

[Guest]

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

 

[NateO]

How's this:

Sub rowNum()
ActiveCell = ActiveCell.Row
End Sub

Cheers, Nate

 

[Guest]

One more question
what should I put if I need the row number of a cell which is NOT SELECTED?

 

[Anne Troy]

How would we know what row that is?

 

[NateO]

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