Macro to assist with formatting.

[TJ Saulnier]

I have a report which is exported to excel and I want to clean it up a little before I work with the data. There are specific rows that I wish to remove since they are extraneous to my work and I'm having some difficulties.

I found the following code snippet from MaczaQ in another thread and modified the find section to look for the text that I want and I modified the result section removing the resize(2) so it only deletes the single row in which the text is located ... Works great ... however I have 6 other strings to look for and delete the corresponding row and I need some assistance in creating a loop that will look for and delete the rows containing the other 6 variables all at once.

Please Login or Register  to view this content.

Thank you in advance for any help you might be able to offer.

[Mumps1]

Try this code. Just replace the "string1", string2", etc. with your strings.

Please Login or Register  to view this content.

[tigeravatar]

TJ Saulnier,

Alternate...

Please Login or Register  to view this content.

[TJ Saulnier]

Hey thanks for the responses ... Tigeravatar I believe your solution is a little closer to what I'm attempting to do ... I do have a couple of questions though .. 1- the line Set rngFound = Columns .. can this be a range of columns A through F ( I neglected to mention in my original post that not all the search criteria is in column A) and 2- when i enter the strings in the array line does it matter if there is other text in the same row following the search string or will the loop evaluate to true if it finds an instance of the string amongst all the text in the cell.

[tigeravatar]

Yes on both counts

[TJ Saulnier]

Excellent .. thanks much for the assist. I have to say as well that this is without question one of the most helpful forums I've ever used. My hats off to you all.