Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a variable workbook be embedded into an Excel funtion?
set rng1 = workbooks("Book1.xls").Worksheets("Sheet1").range( "A1:B10")
set rng1 = workbooks("Book2.xls").Worksheets("sheet3").Range( "C1:C10") res = Evaluate("Not(or(" & rng1.address(0,0,xlA1,true) & "<" _ & rng2.Address(0,0,xlA1,true) & "))") -- Regards, Tom Ogilvy "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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a variable workbook be embedded into an Excel funtion?
Tom,
This works fine. What do the specifications with the () signify below? -- (0,0,xlA1,true) ====================================== set rng1 = workbooks("Book1.xls").Worksheets("Sheet1").range( "A1:B10") set rng1 = workbooks("Book2.xls").Worksheets("sheet3").Range( "C1:C10") res = Evaluate("Not(or(" & rng1.address(0,0,xlA1,true) & "<" _ & rng2.Address(0,0,xlA1,true) & "))") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can not set WorkBook variable | Excel Discussion (Misc queries) | |||
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 |