Usning Cell, Row or Column function in a macro

insane_hound · Mar 30th, 2004, 10:29 AM

Hi Guys,

I need to use the function cell("row",Activecell) or row(activecell) in a macro, however neither of these functions seem to be supported by 'worksheetfunction' in visual basic? Is there away to return the row number of a cell in VB?

Thanks

Regards

Richie(UK) · Mar 30th, 2004, 10:50 AM

Hi i-h,

Just use the Row property, like this:

Code:

Sub Test()
    Dim lRow As Long
    
    lRow = ActiveCell.Row
    MsgBox "Activecell is on row : " & lRow
    
End Sub

HTH

Jaafar Tribak · Mar 30th, 2004, 10:51 AM

Yes :

ActiveCell.Row

Regards.

Mar 30th, 2004, 10:29 AM	#1
insane_hound Join Date: Mar 2004 Location: UK Posts: 3	Usning Cell, Row or Column function in a macro Hi Guys, I need to use the function cell("row",Activecell) or row(activecell) in a macro, however neither of these functions seem to be supported by 'worksheetfunction' in visual basic? Is there away to return the row number of a cell in VB? Thanks Regards

Mar 30th, 2004, 10:50 AM	#2
Richie(UK) MrExcel MVP Join Date: May 2002 Location: UK Posts: 3,333	Re: Usning Cell, Row or Column function in a macro Hi i-h, Just use the Row property, like this: Code: Sub Test() Dim lRow As Long lRow = ActiveCell.Row MsgBox "Activecell is on row : " & lRow End Sub HTH __________________ <font color="blue"> ««« <font color="red">¤ <font color="blue"><font size=+1>Richie </font><font color="red">¤<font color="blue"> »»» </font>

Mar 30th, 2004, 10:51 AM	#3
Jaafar Tribak Join Date: Dec 2002 Location: Larache--Morocco Posts: 2,917	Re: Usning Cell, Row or Column function in a macro Yes : ActiveCell.Row Regards. __________________ Jaafar. Happiness is when what you think, what you say, and what you do are in harmony. http://www.laracheenelmundo.com/

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