I have some code that tests to find a variable within a range. The problem is my data sets can be over 100,000 rows so looping is very inefficient. I do have a find script, but I am stumped on how to use the cell.address combined with lastrow to delete rows from the found value to last row. Below is the loop that shows what I want for a result
Here is my pseudocode of the find sub:Please Login or Register to view this content.
I can use select and delete, but I would like to know how to do this using just the variables.Please Login or Register to view this content.
Bookmarks