sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,404
- Office Version
- 2016
- Platform
- Windows
I'm using this to enter data in the next empty row;
Can anyone show me how to adapt it so that it finds the next empty row within a range, i.e. between A26:A56?
Code:
iRow = ws.Cells(Rows.count, 1).End(xlUp).Offset(1, 0).Row
Can anyone show me how to adapt it so that it finds the next empty row within a range, i.e. between A26:A56?