While working with the code, one small problem is detected, which is big for me, because I find myself unable to solve it.

When all the cells of the table (C4:G6) are empty, and I put any value in the first cell of the table (C4), it gives the following error...

Runtime error '9' : Subscript out of range

Debug.jpg


On clicking on "Debug" option following line is highlighted in VBA
Code:
If arrTbl(Cnt, Clm + 1) >= arrTbl(Cnt, Clm) Then ' we no longer have a decresing sequence
Error 9.jpg