exactly. For instance I have B2-B28 and H2-H97 for OFC and then C2-C28 and
I2-I97 for VACANT. Thank you again!
--
michelle


"Dave" wrote:

Hi,
When you say "I also need to include I2-I28 = OFC AND H2-H28=VACANT"
Do you mean that you now have 2 different ranges? One range in Columns A and
B, and another inColumns H and I?

Dave.