05-22-2007 04:08 AM
05-22-2007 08:38 AM
05-22-2007 10:27 AM
05-22-2007 10:50 AM - edited 05-22-2007 10:50 AM
It's too bad they are not the same since the In Range and Coerce function accepts scalars and array (1D or 2D) inputs. If you stick with the 2D array idea, then the following code will work. You might want to think about keeping the limits in a Excel file. If you save it as a tab or comma separated text file, then you can read in the limits with the Read From Spreadsheet File function.
Message Edited by Dennis Knutson on 05-22-2007 09:50 AM
05-23-2007 05:08 AM
Thanks Dennis,
I will stay with my compairing arrays idea then.
Lama