VBA Scan column is case of blank cell copy the cell to the right in the blank cell

[Numborero]

There is something with the cells in row E and F tried to delete all formulas and make the cells nutral. Save the file in a different formate

Your code works like clockwork in any other cells......

unfortunatly I can't post the file here....