On Mar 2, 6:08 am, "Chrisso" wrote:
Hi All

From reading this group and some of the MVP web sites I have come

across the use of SpecialCells and Intersect as the most efficient way
to loop through data in Excel VB logic.

What I have not found is a concise explanation of why this is so and
what exactly best practice is.

Can anyone point me to some good web resources that discuss the use of
SpecialCells and Intersect?

Cheers
Chrisso

Try the following:

http://www.mvps.org/dmcritchie/excel/proper.htm

-Tim