I am getting this error and where th If not starts its is in red showing that is where the issue is
HTML Code:
I am getting this error and where th If not starts its is in red showing that is where the issue is
HTML Code:
What rows are you trying to remove?
If it's rows that match/don't match a list of values then I'm sure there are better ways to do this rather than the huge Or expression you are trying to use.
For example you could use Application.Match to see if a value in a cell is in the list of values.
If posting code please use code tags, see here.
The current range I am working is is about 85,000 rows long. I need to delete any rows that down contain a certain value in column "B". The list of values to look for in B is 100 values and they are in a worksheet called "100 Airports" in range E4:E103.
I am trying to find the best way to do this because I have other sheets that are huge that contain formulas that search that huge range and it is going so slow. If I can cut the 85,000 rows with the data the formulas is searching for it will hopeffuly speed things up.
What are your thoughs? Thanks for the help
Like I suggested use Application.Match to see if the value in the cell from column B is in the list in column E on the other sheet.
If it is delete the row.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks