Dear all,

I'm trying to create a Macro that finds all blanks in a specific column (for instance "column AG") and for each blank in that column pastes the corresponden right value of the adjacent column (for instance "column AH").

I tried it with a FOR loop on a range adding an IF for cell.Value=vbNullString, but it doesnt work

Could anyone please post any code which could apply? Thank you very much in advance.

(I hope I explain it clear)