Code not working - move rows when cell is less than zero

Code updated with friends suggestion...

Please Login or Register  to view this content.

------------------------------------------------------------------
I have been using the following code for last 2 years and it's worked fine. But I can't understand why it no longer works.

Some background: I have a payment file with two sheets (Queires & Just Giving) the code is supposed to move any rows to the Queries sheet when the payment cell (BU2) is equal to or less than zero (<=)

Please Login or Register  to view this content.

Hi wishmaker. When displaying code, we ask that you use code tags around your code as per rule #3. You have used html tags which are different. I will fix this for you but please remember to use code tags in the future.

Thank you.

The following gives me pause

Please Login or Register  to view this content.

where your criteria to step into the loop is if the selection "BU2" is greater than 0 and then inside the loop you want to copy the rows where "BU2" is less than or equal to 0. My understanding is that your if statement won't work because of your do while statement.

If this is solved, please acknowledge the solution so that others will know if they should happen to peruse this thread.

Thanks!