No idea - it works multiple times for me in a test workbook.

Has your data changed in between runs?

do you have any other macros running?

Step through the code again - where is it acting unexpectedly?

In article ,
TAGyurit wrote:

Thanks for the example. I looked at it and understood the logic, so I
cut & pasted it into a new module of my workbook, stepped thru it, it
seemed to work OK, hit the run button and Viola! It produced the list
just like I needed! But, it has only run properly that one time. Is
there a "magic phrase" I need to say to get it to run again? (I have
uttered several phrases since!) The code executes without displaying
errors, but does not copy any rows to the last sheet, which remains
empty. Why would it run great only once?