Traversing Rows
assuming you mean a row of data
varr becomes a 1 by 1, 1 by 26 array.
Dim i as long, varr as variant, sStr as String
for i = 2 to 20
varr = Range(cells(i,1),cells(1,26)).Value
for j = 1 to ubound(varr,2)
sStr = sStr & varr(1,j) & ","
Next
debug.print i, sStr
sStr = ""
Next
--
Regards,
Tom Ogilvy
"Clarke Fielding" wrote in message
...
I am new at Excel VBA programming and I was wondering
what the best/efficient way of reading in all of the
columns of a given record into variables for processing
and then moving to the next row.
Any help will be appreciated.
|