Hello I am looking to search my spread sheet and delete anything that says "Microsoft" except for "Microsoft Standard 2010".
The problem I am having is it's not skipping to the next instance when it reaches Microsoft Standard 2010. Any suggestions?
Code:Set FoundCell = Range("E:E").Find(what:="Microsoft") Do Until FoundCell Is Nothing If FoundCell.Value <> "Microsoft Standard 2010" Then FoundCell.EntireRow.Delete End If Set FoundCell = Range("E:E").FindNext Loop




Reply With Quote
