Could it be the case that in my excel sheet the cell value is formatted as big decimal and in my outlook vba I am using long/integer. Unfortunately, I cannot change the excel attachment format.

Could this be the reason for subscript out of range error and macro not running properly.

If the excel cell value = -0.2 and iCount value as -15 (this works fine)
If the excel cell value = -10.2 and iCount value as -15 (this gives subscript error)