obtain row of named range?

[eHanSolo]

hi there,

I have a named range of which i'd like to get the row part of the adress of the first and last value of the range (the range is quite large and only a portion of that range has values in it)....

can someone point me in the right direction in doing this in VBA please??

many many thanks,

e

 

[jebenson]

You'll get a better response if you post this in the VBA forum. Here's a link: forum707

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day! Ye has a choice: talk like a pira