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) & "))")