VB Loop in a Loop

I need to create a loop within a loop. First loop works fine as follows:
-------------------------------

Please Login or Register  to view this content.

----------------------------
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

cdemaria

Welcome to excelforum

Please read forum rules & wrap your VBA code - see links below for rules

If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950