Hi,
I need to delete with VBA every row that contains the value "00/00/0000"+ one row before and one row after (3 rows in total).
the values are in column m.
For example:
row 1
row 2
row 3- 00/00/0000
row 4
row 5
row 6- 00/00/0000
row 7
row 8
etc...
In this example, the result needs to be that only rows 1+8 stay.
Thanks
I need to delete with VBA every row that contains the value "00/00/0000"+ one row before and one row after (3 rows in total).
the values are in column m.
For example:
row 1
row 2
row 3- 00/00/0000
row 4
row 5
row 6- 00/00/0000
row 7
row 8
etc...
In this example, the result needs to be that only rows 1+8 stay.
Thanks