View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Kubicki Mark Kubicki is offline
external usenet poster
 
Posts: 89
Default 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...