Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Simple question...
My idea is that when the user clicks a commandbutton, a userform is displayed that is pulling dat from 2 workbooks. I wanted to use a with.range function to populate some of the data from another workbook. In workbook1, I do have a named range referencing data in workbook2, however, when VBA hits that with range statement, it errors out since the worksheet isnt an internal worksheet. Is there a way with the "with range" statement to reference another workbook? That workbook is open. TIA DS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF statements | Excel Discussion (Misc queries) | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
operator statements, shorting when reusing one of the statements? | Excel Programming | |||
If...then statements? | Excel Programming | |||
us IF statements | Excel Programming |