Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
colating multi rows of data into single rows - no to pivot tables! | Excel Worksheet Functions | |||
traversing a filtered range (excel 2007) | Charts and Charting in Excel | |||
Auto extract data & inserts rows additional rows automatically | Excel Discussion (Misc queries) | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) |