If row starts with X, delete 11 rows

[gxm204]

Hello, I am working on cleaning a PDF file with a header that I don't want to include in my text analysis. Each page begins with the phrase "Page X of Y," followed by 10 more lines of header information.

The program I envision would have VBA find each cell that starts with the word "Page."

Then delete that row plus the following 10 rows (total of 11 rows).

This sounds like a good use of VBA but I am too new to write it myself! Thank you all very much.

Best,
George

 

[hiker95]

The user was happy with my script. And this script runs using a loop also.

My Aswer Is This,

That is correct concerning the first part of the above quote.

But, my new code will only loop thru those entries in column A that begin with Page, and, not from the last row of column A, up.

 

[gxm204]

Wow, this is really good stuff, Christmas came early! Thanks so much for your help.

 

[My Aswer Is This]

Not sure what script you used but glad we were able to help you.

Wow, this is really good stuff, Christmas came early! Thanks so much for your help.

 

[hiker95]

Wow, this is really good stuff, Christmas came early! Thanks so much for your help.

gxm204,

Thanks for the feedback.

You are very welcome. Glad we could help.

And, come back anytime.