View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GB GB is offline
external usenet poster
 
Posts: 230
Default For index = 2 To Source.Rows.Count

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