Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following:
F | G| H | I | J |K .... to T Sum of Error 1 2 4 3 1 1 1 3 2 1 1 1 2 4 1 2 3 1 1 1 1 1 1 0 4 .. The numbers represent error codes. Up to now I have created a vba macro that creates an array for each learner with the number of errors they got. I now need to match the error codes against another table in another worksheet. How do I traverse from F to S ? ie what methods are available and the syntax please. Going down to get the error was easy as I created an index and did x + 1 and concatenate this to the column Letter but I am not sure how to traverse across. Regards in advance Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
traversing a filtered range (excel 2007) | Charts and Charting in Excel | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Traversing two named rages of unequal length | Excel Programming | |||
traversing through a filtered range based on another filtered range | Excel Programming | |||
Traversing Rows | Excel Programming |