My macro runs a loop on the used range.

However, if the used range is originally 150 rows, but then I delete a lot of the data and make it 50 rows, it will still run through the original usedrange.

Anyone know how to fix this? It wouldn't be a problem except for the fact that this is a very slow code as it is.