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...

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...

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

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...