Ah,
I've made it. It's actually quite simple.
(remember, I have to filter for the lines that I do not want, in this instance all the blank lines in a file which could irritate my macro and lead to wrong results)
- After filtering (on a field that I am sure will be filled only if an employee has really entered data in that row), I select the header_row;
- Then I just move down one row;
- Then I use xlDown to select one column down to the end of the table_object;
- Using >> Selection.EntireRow.Delete <<, I can quite easily delete the entire rows belonging to the range I have just selected.
=> By then selecting the header_row again and removing the filters, I have effectively removed all the lines that I do not want.
Thus, this is closed and solved.
|