Find and Delete Row

[ashleykelley]

I have this in my macro and it goes through and finds the text blankerror and deletes that row. Only problem is it takes too long. Is there away to do that without using a loop? or do i just need to name the range. The range that blankerror exists in is B2:B100 .. not anywhere else in the sheet....

Please Login or Register  to view this content.

[VBA Noob]

This link should help

http://www.rondebruin.nl/delete.htm

VBA Noob