Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named Range From One Workbook Used in Validation Drop Down in 2nd Workbook | Excel Discussion (Misc queries) | |||
Named Range in ANOTHER workbook | Excel Discussion (Misc queries) | |||
Named Range in ANOTHER workbook | Excel Discussion (Misc queries) | |||
Named Range in another workbook | Excel Worksheet Functions |