Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a variable workbook be embedded into an Excel funtion?
Jeff,
Dim wbk1 as String, wbk2 as String, wsh1 as String, wsh2 as String wbk1 = "Myworkbook" wsh1 = "Mysheet" Range("A1").Formula = "=[" & wbk1 & ".xls]" & wsh1 & "!A1" start from here and build. You could also Dim these as Workbook and Worksheet objects to change Workbooks("Myworkbook.xls").Sheets("Mysheet").Rang e("A1") to Set wbk1 = Workbooks("Myworkbook.xls") Set wsh1 = Sheets("Mysheet") wbk1.wsh1.Range("A1") steve "JeffFinnan" wrote in message ... Previously, I had queried about comparing ranges as to whether they were exactly the same as each other Tom Ogilvy had suggested using something like this: ? Evaluate("=NOT(OR(A1:B10<C1:D10))") False Range("C1:D10").Value = Range("A1:B10").Value ? Evaluate("=NOT(OR(A1:B10<C1:D10))") True The question I have now is how can I use a variable name or some separate worksheet references for the ranges within the Excel function? By this I mean each range could be a variable workbook and work sheet as well as a variable range. Thanks, Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save an embedded workbook in PPT | Excel Discussion (Misc queries) | |||
If funtion in Excel | Excel Worksheet Functions | |||
Excel Funtion | Excel Worksheet Functions | |||
Create an external reference link with embedded variable | Excel Worksheet Functions | |||
Can a variable workbook be embedded into an Excel funtion? | Excel Programming |