jeudi 10 décembre 2020

VBA, FOR LOOP, IF statement , get the value of the previous cell

I would like to write a vba script that goes down in a coulumn for example from K2 till the last cell in coulumn k (i want it dynamic), and it checks every cell and if a cell is 0 then that cell should get the value of the previous cell.

I hope its understandable. If not feel free to write me and i can explain it more.

Thank you for your kind and fast help in advance.

Best regards, Balazs

Aucun commentaire:

Enregistrer un commentaire