Prema
08-13-2010, 12:44 AM
Hi again,
I would greatly appreciate if members can assist me with the below issue.
I am trying to delete all the (entire) rows from all worksheets In all workbooks in a folder based on a specific cell value.
I managed to find all the cells with specific value and also entire row addresses of all the selected cells and then I am deleting the rows.
But while doing so if that specific value exists in two different cells of one row, then the code will delete the row twice (First it will delete the row with specific cell value and also it will delete the row below the specific cell value).
But I want delete only that specific row that contains cell OR cells with specific value.
How can I modify this. ?
Any and all assistance is highly appreciated.
I can forward the code if you need more info on this.
Thanks in advance,
Prema
I would greatly appreciate if members can assist me with the below issue.
I am trying to delete all the (entire) rows from all worksheets In all workbooks in a folder based on a specific cell value.
I managed to find all the cells with specific value and also entire row addresses of all the selected cells and then I am deleting the rows.
But while doing so if that specific value exists in two different cells of one row, then the code will delete the row twice (First it will delete the row with specific cell value and also it will delete the row below the specific cell value).
But I want delete only that specific row that contains cell OR cells with specific value.
How can I modify this. ?
Any and all assistance is highly appreciated.
I can forward the code if you need more info on this.
Thanks in advance,
Prema