Delete values in last cell of rows based on values in other cells
Posted on 2013-10-17
My current document has hundreds of tables. I would like to perform the following task using VBA.
As soon as the macro hits the value '99-99' (The value '99-99' is always located in the first cell of any row) in any of the rows, the contents of the last cell in that row is to be deleted.
All of the tables in this document feature the exact same number of columns.
Help is much appreciated. Thank you very much in advance.