Good day friends,
The code down below counts all cells from column A2 to I11.
The problem; the code should stop counting if there is a blanc cell in a column and go to the next column to countinue .
My query; how should the code be modified so it will stop counting if there is a blanc cell.
Thank you for any help offered!
Greetings from Roberto, The Netherlands
Set Rng = ActiveSheet.Range("A1:I1") For Each Cell In Rng Cell.FormulaR1C1 = "=IF(COUNT(R2C:R[10]C),COUNT(R2C:R[10]C),"""")" Next Cell
Bookmarks