Try

Range TheRange
TheRange = Workbook.Names("Calcs").RefersToRange

This assumes that the name "Calcs" refers to a range. It is possible
to have a Name that refers to a constant or formula rather than a
range.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Tue, 9 Dec 2008 07:20:17 -0800, Jorge Ribeiro
wrote:

Hello

I've a named range "Calcs".
I want to get an Excel.Range object that reference that particular named
range.
I could do this iterating workbook.names collection but it seems to me that
there must be another way to accomplish this.

Can you help me here?

Best regards

Jorge