Bob,
Unless the code is run in the upcoming Excel 12, which a limit of 1 million
(?) rows.

NickHK

"Bob Phillips" wrote in message
...
Rows.Count will be 65536 for any sheet, including Source, unless it is
not
a worksheet, when it will error. So it will always run 65535 times, unless
index gets incremented inside the loop.

--

HTH

RP

"GB" wrote in message
...
It means, that basically to start from Row 2 of the worksheet called
Source
and go until the last row of Source. If Source.Rows.Count is less than
2
then the for loop is bypassed. If that function returns 2 then the for
loop
is run one time. The code between the first For and the "next for"
related
to this will be run the number of times given by the difference of
Source.Rows.Count and 2. (No it can not be "undone" by a negative
value.
:) )


"ca1358" wrote:

For index = 2 To Source.Rows.Count

What does the 2 mean in this line
--
ca1358