The magic is not knowing what TRUE/FALSE does as an argument to the Select
method, but it is the elegant way of not having to set up if ... else ....
end if clause to separate treatment. I am going to be on the lookout for
opportunities to do that when an T/F argument varies under two mutually
exclusive conditions like shown ... i.e., something either IS or IS NOT =
Mylimit.

Beautiful.



"snax500" wrote in message
oups.com...
It really is. I wrote to Dave for an explanation. Here it is...



Take a look at help for .select.

It has an option to replace the selected sheet or keep adding.

False means that it's just "added" to the current group of selected
sheets.

True means to select that sheet and "unselect" the previous sheets.

I want True only on the first worksheet in that group--when (ictr =
mylimit
+ 1)

mylimit = 2

Then ictr = 3 (the first of the group).

The next time through, ictr will be 4
4 is different from mylimit + 1 (=3) so it evaluates to False--and so
that
second (and all subsequent sheets get added to the group.


Thanks again Dave.