cell address..

[peterlee516]

Hi,

How can I retrieve the row of the selected cell? I am pretty new to VB
so can you explain every step.

Thank you in advance

 

[Frank Kabel]

Hi
sub foo()
msgbox activecell.row
end sub

 

[Tom Ogilvy]

msgbox Activecell.row

msgbox Selection.Address

for multiple cells selected and you want the whole selection.

 

[Jan Karel Pieterse]

Hi Peterlee516,

How can I retrieve the row of the selected cell?

MsgBox Activecell.Row

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Bob Phillips]

The selection can be many cells ( and many rows) whereas the activecell
is just one, so I will use activecell

thisRow = Activecell.Row

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)