Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet collection issue
trying to get a reference to a named range in a different (open) worksheet:
this result in an error (9): Workbooks("Book1.xls").Worksheets("Sheet1").Range( "RateDesigner") when i type the final dot after: workbooks("Book1.xls"). i get a drop-down list that includes: worksheets when i type the final dot after : worksheets(). i get a drop-down list; but, it does not include: range when i type the final dot after worksheets("Sheet1"). i do not get even a drop-down list suggestion ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with data collection! | New Users to Excel | |||
Excel Worksheet Password Issue!!!!! | Excel Discussion (Misc queries) | |||
Help with Worksheet issue | Excel Worksheet Functions | |||
Referencing worksheet issue | Excel Discussion (Misc queries) | |||
Is a Collection the best option? | Excel Programming |