I need a macro that will go through all the cells in column B and if the text in the cell does not match one of the states listed in the code then the entire row needs to be deleted. Also it needs to skip over any blank rows and not delete them.
Thanks any help is greatly appreciated.
Here's my code.
Please Login or Register to view this content.
Bookmarks