Hi All
How would I modify the below simple code which looks for the first empty cell in Column A within the whole workbook, so that it only searches for the first empty "A" cell within a range of rows? As it works from the bottom of the sheet up, and I have data below the area I wish to search, it does not work for my needs.
I'm looking to search between Rows 13 - 32 only. It should be simple, I know, but I need some help.
Thanks
How would I modify the below simple code which looks for the first empty cell in Column A within the whole workbook, so that it only searches for the first empty "A" cell within a range of rows? As it works from the bottom of the sheet up, and I have data below the area I wish to search, it does not work for my needs.
Code:
Cells(Rows.Count, 1).End(xlUp).Offset(1).Select
I'm looking to search between Rows 13 - 32 only. It should be simple, I know, but I need some help.
Thanks