Writing arguments in macro codes

[kosherboy]

Hello all!

I am trying to have my code work based off a complicated argument. If it helps understand my issue better my code checks every row of data that falls under the argument and copies the row to a different sheet.
The rows to be copied must have range A and L populated and range X empty, the tricky part is that the row must also have either range M or O populated in order for the row to get copied, if neither M or O are populated then the code should not copy the row, if both M and O are populated then the row is good to be copied.

Here is how i wrote the actual code but it's causing my code to bug.

Please Login or Register  to view this content.

My code does work fine when i replace the "Or" with an "And".

Anyway, hope to see responses!
Thanks in advance

[Winon]

Hello kosherboy,

Try it this way:

Please Login or Register  to view this content.

Regards.

[kosherboy]

Thank you Winon, that seemed to do the trick!

[Olly]

Try:

Please Login or Register  to view this content.

You missed out the bits I have highlighted in red

[TMS]

Maybe:

Please Login or Register  to view this content.

Regards, TMS

[kosherboy]

Try:

Please Login or Register  to view this content.

You missed out the bits I have highlighted in red

Hi Olly,
Thanks for responding. Winons reply works fine, are the parenthesis imperative to the code? What would happen if i omit them?

[Winon]

You are welcome, kosherboy.

Glad I could help, and thank for the Rep.

Regards.

[TMS]

You're welcome. Thanks for the rep.