refferencing named range in different workbook
 

what am I getting wrong,?

the desired result is the value of the named range in a different workbook
which is hidden, but open...

in the different workbook: Job Nos for Timesheets.xls,
on worksheet: Billing Rates,
a named range is defined as: RateDesigner = 'Billing Rates'!$C$13

the code that is failing is:

Dim curFeeRate As Currency
Dim rngFeeRate as Range
....
set rngFeeRate = Range("Job Nos for
Timesheets.xls!RateDesigner")
feerate = rngFeeRate.value


some of the other variations have been:
Range("[Job Nos for Timesheets.xls]!RateDesigner")
Range("[Job Nos for Timesheets.xls]Billing Rates!RateDesigner")
Range("workbooks(Job Nos for Timesheets.xls).worksheets(Billing
Rates).!RateDesigner")


thanks in advance...

refferencing named range in different workbook
 

Try:

Workbooks("Job Nos for Timesheets.xls").Worksheets("Billing
Rates").Range("RateDesigner")

--

Vasant


"Mark Kubicki" wrote in message
...
what am I getting wrong,?

the desired result is the value of the named range in a different workbook
which is hidden, but open...

in the different workbook: Job Nos for Timesheets.xls,
on worksheet: Billing Rates,
a named range is defined as: RateDesigner = 'Billing Rates'!$C$13

the code that is failing is:

Dim curFeeRate As Currency
Dim rngFeeRate as Range
....
set rngFeeRate = Range("Job Nos for
Timesheets.xls!RateDesigner")
feerate = rngFeeRate.value


some of the other variations have been:
Range("[Job Nos for Timesheets.xls]!RateDesigner")
Range("[Job Nos for Timesheets.xls]Billing Rates!RateDesigner")
Range("workbooks(Job Nos for Timesheets.xls).worksheets(Billing
Rates).!RateDesigner")


thanks in advance...

refferencing named range in different workbook
 

Workbooks("NameBook1").Worksheets("name1").Range(" Name1").value
"Data"

or


Workbooks("NameBook1").Worksheets("name1").Range(" Name1").value
Workbooks("NameBook2").Worksheets("name2").Range(" Name2").value
"Data"

or

Dim wsBook2 as Worksheet
wsBook2 = WorkBooks("Name2").WorkSheets("Name2")

wsBook2.Range("A1").Value = "Data

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

refferencing named range in different workbook
 

set rng = Workbooks("Job Nos for
Timesheets.xls").Names("RateDesigner").RefersToRan ge

--
Regards,
Tom Ogilvy

"Mark Kubicki" wrote in message
...
what am I getting wrong,?

the desired result is the value of the named range in a different workbook
which is hidden, but open...

in the different workbook: Job Nos for Timesheets.xls,
on worksheet: Billing Rates,
a named range is defined as: RateDesigner = 'Billing Rates'!$C$13

the code that is failing is:

Dim curFeeRate As Currency
Dim rngFeeRate as Range
....
set rngFeeRate = Range("Job Nos for
Timesheets.xls!RateDesigner")
feerate = rngFeeRate.value


some of the other variations have been:
Range("[Job Nos for Timesheets.xls]!RateDesigner")
Range("[Job Nos for Timesheets.xls]Billing Rates!RateDesigner")
Range("workbooks(Job Nos for Timesheets.xls).worksheets(Billing
Rates).!RateDesigner")


thanks in advance...