Why is that the VBA shows an error log when I try to insert this formula:
ActiveCell.Offset(j - 1, 3).Formula = Var1 & "/" & ActiveCell.Offset(j - 1, 2) * Lote
if Lote = 1 >>> theres no error
if lote < 1 >>> theres an error!
I also tryed:
ActiveCell.Offset(j - 1, 3).Formula = Var1 & "/" & ActiveCell.Offset(j - 1, 2) & "*" & Lote
and reached the the same results
does anyone has a clue?
tks
Cesar
ActiveCell.Offset(j - 1, 3).Formula = Var1 & "/" & ActiveCell.Offset(j - 1, 2) * Lote
if Lote = 1 >>> theres no error
if lote < 1 >>> theres an error!
I also tryed:
ActiveCell.Offset(j - 1, 3).Formula = Var1 & "/" & ActiveCell.Offset(j - 1, 2) & "*" & Lote
and reached the the same results
does anyone has a clue?
tks
Cesar