I imagine someone will prove me wrong, but if you have a hundred non-
contiguous areas to handle, there is no practical way to do this
without a loop. It almost appears to be a homework assignment. Is it?
If so, ask the professor for some tip(s) on what s/he expects.

That said, if you can treat all the non-contiguous areas as a single
contiguous area and just make it look like they are non-contiguous, you
may be able to use a XL formula that returns "" for all the cells that
should appear blank.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...


oh no.....
it is example only.
if 100 line, i have to do 100 line typing..
it is not.
i want to use the union method or array.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!