Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Simple one - I think!
My main application (Excel Workbook) opens another workbook with named range(single cell). How can I refer to these named ranges and return the value. In the following code I am trying to set the sheet shControl (codename) range A1 to the value in the dataWb named range "OptRef" Dim dataWb as Workbook Set dataWb = Workbooks.Open(myfile) With dataWb.Sheets("Sheet1") shcontrol.range("A1") = ???? End With TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
referencing a 3D Named Range | Excel Worksheet Functions | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
Referencing a Dynamic Named Range in VBA | Excel Programming | |||
referencing a named range from a closed workbook | Excel Programming | |||
VBA Referencing a Named Cell Range in another Workbook | Excel Programming |