get row index of a cell in VBA

[BarbE]

Hi

This is driving me crazy ... I know I should know how to do this but I can't get my memory working today.

Can someone help me out here please?

All I need to know is how to write in VBA rows(a2), ie get the row index of a specific cell.

Thanks a lot!

Barb

 

[lord of the badgers]

MyAddress = activecell.row

 

[BarbE]

MyAddress = activecell.row

THANKS!!!!!!!!!!

 

[jpjeffery]

Loving the choice of image for your avatar, lord of the badgers. PT rock!

And thank you for the code I needed (but someone else asked for). The internet is a wonderful thing.