Hi guys I have looked this up in the forum for answers but they all seem to return the below code as a solution.
This works fine to go the 1st blank at the end of a column but I have a few blank cells in the middle of the column of data and I want to go to that 1st empty cell, not the end. Any idea's ?
Range("A" & Rows.Count).End(xlUp).Offset(1).Select
This works fine to go the 1st blank at the end of a column but I have a few blank cells in the middle of the column of data and I want to go to that 1st empty cell, not the end. Any idea's ?
Range("A" & Rows.Count).End(xlUp).Offset(1).Select