row number

Mar 4th, 2002, 09:26 AM

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

NateO · Mar 4th, 2002, 09:32 AM

How's this:

Sub rowNum()
ActiveCell = ActiveCell.Row
End Sub

Cheers, Nate

Mar 4th, 2002, 10:37 AM

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

Anne Troy · Mar 4th, 2002, 11:00 AM

How would we know what row that is?

NateO · Mar 4th, 2002, 12:08 PM

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 ]

Mar 4th, 2002, 09:32 AM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	How's this: Sub rowNum() ActiveCell = ActiveCell.Row End Sub Cheers, Nate __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

Mar 4th, 2002, 11:00 AM	#4
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	How would we know what row that is? __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 09:26 AM	#1
Guest Posts: n/a	Hello people Do you know what's the syntex to return the row number of the selected cell in excel by using VB ?

Mar 4th, 2002, 10:37 AM	#3
Guest Posts: n/a	One more question what should I put if I need the row number of a cell which is NOT SELECTED?

Mar 4th, 2002, 12:08 PM	#5
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	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 ]