I would like to have some code that will go through the entire sheet and delete rows based on any data in Col I. If Col I is blank then do nothing.
I have searched the forum and read the threads on deleting rows found here http://www.xtremevbtalk.com/showthread.php?t=300757
I tried the method in post #5. I am getting an error "Run-time error '1004':
A range is required.Select at least one cell within a range and try again."
This occurs at the line ".AutoFilter field:=9, Criterial:="<>" & sTOFIND" in the code below.
I have read all the posts I could find searching on 'delete rows' and can not find anything that helps me to get this working.Please Login or Register to view this content.
The code above is copied from the above mentioned forum post. I changed so it will look at column I (or 9) I believe... I could be wrong there. I also changed the ILastRow line.
I am using Office 2011 for Mac. Not sure if that makes any difference or not.
Any ideas?
Thanks
Bookmarks