Yes, it was my mistake. It does work if the range starts in A1. Otherwise,
wrong answer.
See my previous post stating this.

--
Regards,
Tom Ogilvy

"papou" <cestpasbonprobin@çanonpluscg44_fr wrote in message
...
Hello Tom
The sample code I provided does not use the syntax you mention.
I tested succesfully on my Excel 2003.

Cordially
Pascal

"Tom Ogilvy" a écrit dans le message de
...
myname().Value would raise an error. An array doesn't have an address
property.

--
Regards,
Tom Ogilvy

"papou" <cestpasbonprobin@çanonpluscg44_fr wrote in message
...
Hello Steph
This will return address of the bottom left cell:
MyName = ThisWorkbook.Names("YourName").RefersToRange.Value
MsgBox Cells(UBound(MyName, 1), LBound(MyName, 2)).Address

HTH
Cordially
Pascal

"Steph" a écrit dans le message de
...
Anyone know how to programatically find the bottom left cell of a
named
range? I need to find that cell, and insert an entire row beneath
it.
Thanks!