Hi,

I have a macro that has For Each loop and If statement. If the condition is true, the macro will copy a row in one sheet into another and this is working fine. My problem is that if the condition is false the macro leaves a blank row in the other worksheet. It looks like, the macro is still copying but because the condition is not met it leaves a blank row.

Can anyone please explain how to avoid the blank rows.

Thanks
Khalil

u need to post the code so we can see what's going on

Thank you for trying to help.

Luckily I've found the problem and resolved it.

Regards
Khalil