Hi,
I am trying to work with a workbook that has one sheet containing nearly 100 combo boxes. Each row would contain about 8 boxes that allow the user to select info.

The sheet itself was not designed by me and redesigning is a not an option.

Is there a way to go through each combo box by row and retrieve its info without having to reference them by name..

Eg
Start at row 1
Take information from the combo box at A1, B1, C1, D1 etc then
Then move to row 2 until end of the rows I specify.