Assume I place 5 rows of data starting in cell R1:R5. Then as I receive new data I add it to the next column, same rows (S1:S5). This continues on until I am through adding data. Assume I am finished adding data when I add data in V1:V5. So I have 5 columns of data (R thu V). Assume I keep a count of the number of columns with data in cell A1. It would equal 5 in this case.

Now, I want to place 0 in each of these cells that I have data. The coding needs to be able to support a variable number of columns because the next time I may have some other number of columns with data.

How do I code for a variable number of columns and replace the data?