I need to select the cells in column A untill there is no data anymore.
The problem is that sometimes there is 1 empty row and my current macro stops at that row.
In column C there are no empty rows so macro can count this column and then select cells in column A.
Hope somebody can help me.
See attached file as well.
Thanks!!!
Bookmarks