#N/A clear by For n ... next n

Hi All,
In my sheet with data I have for each of six columns about 50 000 records per column. For most of cells (95%) cells.text = #N/A. I want to clear cells when cells.text = #N/A. For rest of them I input for each of columns correct value.
For each of column I have separate For n … next n. What is more in turn off the Screen Updating to make the process faster.
My question is. Is there any chance to make the code faster? Maybe you have a proposal for my how to make the process faster?
Many thanks in advance.
Regards,
Maciej

Please Login or Register  to view this content.

Excellent idea. I have not known syntax so far.
This is great improvement. Do you have another brilliant idea for me. How to speed up the process with inputting different value for each columns?

Many thanks in advance!

Please Login or Register  to view this content.

By the way...
If I use

Please Login or Register  to view this content.

Is the code correct (for me it works)? Could I use it instead

Please Login or Register  to view this content.

Could I expect that those two examples will give me the same results?

Many thanks in advance

Regards,
Maciej