http://www.j-walk.com/ss/excel/usertips/tip073.htm

try it

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



" escreveu:

Hi everyone,

I have two Excel spreadsheets. On one of them i have two collumns that
contains a range of number. Like in cell A1 there is the number 2470000
and in the cell B1 there is 2470099. On the second spreadsheet, there
is 2470000 in the cell A1 and 2479999 in cell B1. What i need to do is
to check if the range of number i have on the first spreadsheet is
included in the range of the second spreadsheet. Any idea how i could
do that.

Thanks in advance !