How do I get full Name into a Variable? [Archive]

View Full Version : How do I get full Name into a Variable?

Robin McLean

11-11-2010, 05:51 AM

I want to select the worksheet of a Name.

I have tried
FullRangeName = ActiveWorkbook.Names

I would like to see FullRangeName have the value =Sheet3!$E$4:$E$5

Many thanks

Robin

Bob Phillips

11-11-2010, 09:42 AM

Do you mean

FullRangeName = ActiveWorkbook.Names("thename").RefersTo

Robin McLean

11-11-2010, 10:21 AM

Thanks - this now works perfectly.