defining an array and deleting values

[Tortus]

Hello. I may be way off track here but would like some help. I'm not sure how to make the array part of what I'm trying to delete.

Please Login or Register  to view this content.

[JieJenn]

Give this code a try (untested).

Please Login or Register  to view this content.

[Tortus]

This works but I have a question. It doesn't get everything in 1 run. I have to run this 3 times which is odd to me. I thought that each loop starts with A1....

Thanks you for the help!

[JieJenn]

Instead use For Each, use Loop instead (For i = 1 to LastRow)

[Tortus]

OK! thank you very much! works well!

[nilem]

or maybe so

Please Login or Register  to view this content.