Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For index = 2 To Source.Rows.Count
For index = 2 To Source.Rows.Count
What does the 2 mean in this line -- ca1358 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
For index = 2 To Source.Rows.Count
It is the first number to start your count by. You are essentially counting
from index to Source.rows.count index starts at 2 and is then incremented in the code that follows. "ca1358" wrote: For index = 2 To Source.Rows.Count What does the 2 mean in this line -- ca1358 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
For index = 2 To Source.Rows.Count
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
For index = 2 To Source.Rows.Count
Running to the end of the rows seems superfluous, it should check for the
end of the data to stop unnecessary iterations of the loop. -- HTH RP "ca1358" wrote in message ... For index = 2 To Source.Rows.Count What does the 2 mean in this line -- ca1358 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
For index = 2 To Source.Rows.Count
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count, Sum, Index,Match or other formula needed | Excel Worksheet Functions | |||
INDEX/MATCH automatic updates while source files are closed | Excel Discussion (Misc queries) | |||
Index/Match to get Count (from Subtotals) into a Table of Names | Excel Worksheet Functions | |||
Using INDEX w/MATCH to get data from unsorted source | New Users to Excel | |||
find out line count source in vbe | Excel Programming |