Macro Amendment Required For Calculation Code

Hi Could someone take a look at this for me please, Kindly donated by Excelx. What the code does is calculate how many pallets I have on an order.

Basically it starts at the 10th Column (J) and goes along 3 steps at a time till it finds data then goes down the column and calculates the pallets by taking that data and also some data in rows 7 onwards

The problem I am getting is when I get to the last column , column 31 (AE) it does not give me any calculations at all. J , M , P, S , V , Y and AB seem to work ok as far as I can make out.

I have attached a sample to show you what I mean, it has data up to AB and seems to work ok but put data into AE and it stops, I have also noticed if I take data out of one of the columns it does not give me a correct reading. The data in AB should read 6 pallets and it does but if I take the Data out of Y column the calculation for AB changes.

Is there a problem with the code or is there another way I could do this?

Code

Please Login or Register  to view this content.