I have a worksheet where I need to delete dynamic text on 3 columns .
First columns A the word Page :, then Page :1 , Page: 2, Page : 3 and so on .
But on column A there is Page Number : 1 , Page Number :2 and so on but these should not be deleted
On column H and I the word Page Number on H and the numerical data 1 which is always next .
The sequence is always the same but the row no differ a lot .
Column A , H and I maximum rows are 5000
looking a vba code to handle this
Bookmarks