Macro that deletes all rows that does not contain ## or **

[mingandmong]

Hi
I'm using excel 2010

I need a macro that deletes all rows after row 10 that does not contain these special characters as shown

## and ** that are always on separate rows on a data log file I just need to strip all redundant data

Thank-you in advance

 

[mingandmong]

Hi Peter
THankyou for re-looking at the macro
unfortuanley i recieve a debug... a compile error invalid outside procedure
if i can be of any more assistance or help you more to identify the issue then please ask
thankyou for your valuable time and pationce

 

[Peter_SSs]

When you get that message, something in the vba window should get selected/highlighted blue. I think you must have some other line(s) of code other than what I posted, or else you missed a bit of my code when you copied it from the forum.

 

[mingandmong]

Peter

End Sub is in blue

There is only your code and no other macros i have pasted the code again, and still the same End Sub is highlighted blue

 

[Peter_SSs]

Sounds like you have some stray code somewhere. I just re-copied the code from the forum back into my sheet & it is working fine.
Suggest test by closing all your workbooks, start a fresh one, copy/paste the code from the forum and test. For the test, it doesn't even matter if there is no data in the sheet, but you could put some in if you want.

 

[mingandmong]

Hi Peter
Closed the book re-opend and re-pasted, your a genious thank-you for all your hard work, much apprecieted that you spend time helping us unfortuante people to better oursleves

 

[Peter_SSs]

Hi Peter
Closed the book re-opend and re-pasted, your a genious thank-you for all your hard work, much apprecieted that you spend time helping us unfortuante people to better oursleves

Glad you got it sorted & you are welcome. People did the same for me when I was staring out, so I understand what you are saying.