have sheet with table in the middle,
ive been using a snippet which counts the entire page and finds first empty row, ive tried now for hours but cant seem to figure out how to modify it to only count a specified range, or the table itself. code snippet:
iRow = ws.Cells(Rows.Count, 1) _
.End(xlUp).Offset(1, 0).Row
any ideas?
ive been using a snippet which counts the entire page and finds first empty row, ive tried now for hours but cant seem to figure out how to modify it to only count a specified range, or the table itself. code snippet:
iRow = ws.Cells(Rows.Count, 1) _
.End(xlUp).Offset(1, 0).Row
any ideas?