Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a named range in another workbook
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a named range in another workbook
shcontrol.range("A1").Value = .Range("OptRef").Value
-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Nigel RS" wrote in message 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a named range in another workbook
Thanks Jim, I got tangled up in using the workbook Names collection and lost
sight of the Range ! -- Regards, Nigel "Jim Cone" wrote in message ... shcontrol.range("A1").Value = .Range("OptRef").Value -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Nigel RS" wrote in message 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |