need help fixing my VBA

Current VBA

Please Login or Register  to view this content.

Currently this allows me to search any column I choose and look for whatever I specify and then it deletes any row that contains what I specified in that column.

I run the code and the first input box asks what column and I say "I" then I run the code and it asks what to search for in that column I say "day" then it searches every column looking for the word day and if it finds it it deletes the row that day was found in.

Here is what I need it to do:

Ideally the code would not loop as the spreadsheets I am working in have tens of thousands of lines and it takes a long time to run.

Secondly, I need it to be very specific, I type "day" and it deletes any row that contains the letters "day" so if a row contains everyday or daylight or dayton, etc. it deletes that row and I don't want it to do that. Sometimes I will have this search for a single letter or number and delete that row and I cant have it delete every row that contains the letter "D" I only want it to delete rows that only contain a letter "D" and nothing else. Unfortunately I am not very versed in VBA so what I am asking goes beyond my skill level. Thanks

This can be done but it's best to post a workbook with dummy data to prevent back & forth posting for code adjustments. If I did exactly as requested you would end up with only one column with data, the rest of the sheet blank

Sorry here you go. Looking at column M and removing Day.