Problem using a For loop with Step to read to the end of file
Posted by Stephen on October 05, 2000 9:05 AM
I would like to learn how to make the macro I am using read to the end of the file with out having to put the number of rows in each time. It looks soming like this: For y = 1 To 30886 Step 60
pcount = pcount + 1
For x = 1 To 11
array1(pcount, x) = space(y, x).Value
Each time I have to put the number of row(30886) in the file in order for it to loop to the end of file. If anyone could help I would by very thankfull, Thanks.