I need to create a loop within a loop. First loop works fine as follows:
-------------------------------
----------------------------![]()
x = 0 Dim DirArray(0 To 80) As String Dim intI As Integer For intI = 0 To 80 DirArray(intI) = Range("start").Offset(intI, 0).Value Next For x = 0 To 80 lob = DirArray(x) Range("lob") = lob Calculate Sheets("WBB LOB Summary").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Next
At the 'start' point, first loop works downward through rows. Second loop would work across columns in each row within the first loop. I will have to use a variable for 'y' (the across value) b/c the number of cells containing data can vary between 3 & 9, but I have a COUNTA in each row setup to use as the variable.
So spreadsheet data would look like this with A being the 'start' cell:
A 1 2 3
B 1 2 3 4 5 6
C 1 2 3 4
I need to pickoff A1, A2, A3, B1, etc, picking up every sub-category on the sheet.
Thanks in advance!
Chris











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks