Currently I do this:
Code:
For CurrentTableRow = WallTableBeginsRow To WallTableBeginsRow + NumberOfWalls
If (Cells(CurrentTableRow, BwkBlkStudCol).Value = "Bwk") And (Cells(CurrentTableRow, FloorCol).Value = "GF") Then
GFBWKArrayNumber = GFBWKArrayNumber + 1...