Deleting a number of separate rows at the same time

There seems to be a limitation in the number of separate lines that can be deleted which is causing this routine a problem. Can anyone think of another approach I can try?

Please Login or Register  to view this content.

I must honestly admit that I am having trouble understanding your code but I played around a bit with ranges and the union instruction and was able to build a range of 500 individual rows and delete them without a problem using the code below. Perhaps that is something to explore?

Please Login or Register  to view this content.

PS writing the value "to_delete" to cell A is just for testing purposes and not needed

Cheers for that, with a bit of fiddling I changed

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

for

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

and it works ?

It does indeed. I had to set it up that way as I would never know which was the first range to set for deletion. it did throw up later an out of memory message though, I'm not sure if it is related.