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