Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranges and VBA Add-ins
Tom,
Thanks for replying so promptly. That code: ThisWorkbook.Names.Add Name:="LondonHolidays", RefersTo:="=[gbcmcrolib.xla]LDN!$B$2:$B$24" ThisWorkbook.Names.Add Name:="NonReportingFridays", RefersTo:="=[gbcmcrolib.xla]LDN!$G$2:$G$16" is in the Workbook_Open event of the XLA workbook(GBCMCROLIB). Is there anything else I can try? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named Ranges | Excel Worksheet Functions | |||
Named ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Worksheet Functions | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Worksheet Functions |