Help :s

[Moemennada]

I am facing kind of a unique problem
i made a work book that is supposed to calculate packaging requirements for a production plant
the macros on it was working fine until one day it started to stop working over an " over flow Error " due to failure in referencing cells with the required values

for example : i have this condition
' here is supposed to be the if condition to calculate the Requirements for the Packaging

If Worksheets("Order Form").Cells(Row1, 6) = "Cartons" Then
    Cans = Worksheets("Order Form").Cells(Row1, 5) * Worksheets("Packaging Materials").Cells(Row2, 4)
    Else: Cans = Worksheets("Order Form").Cells(Row1, 5)
    End If

sometimes i find the VBA recognizing the value of variable "cans" as "zero" and sometimes i find it as the required value
without any significant change on my part

 

[VoG]

How did you Dim Cans? It should probably be a Long.

 

[Moemennada]

How did you Dim Cans? It should probably be a Long.

i dim them as integers but is an integer
because there is no fractions in 'cans'
only whole numbers because 'cans' is not divided by anything

also i would like to highlight that it was working fine before and for a year
it started prompting errors all of a sudden and with no apparent reason
and also the run time error debugging is always in a different place in the code
and always linked to worksheet r1c1 referencing code lines

 

[VoG]

So try Long

 

[Moemennada]

i tried now all variables as long and no difference ...