If the macro's condition is not met then run another macro

[shinobi]

Hello,

The macro below cuts all rows that have "1" in column F and and then pastes them into sheet2. I would like to modify it as follows: if there are no cells in column F with "1" then I'd like to run another macro (if no "1" in F then call macro 2). I'm not sure how to put it and where to put it.

I'd appreciate any suggestions.

Regards,
shinobi

Please Login or Register  to view this content.

[wotadude]

like this maybe -

Please Login or Register  to view this content.

[shinobi]

Hi wotadude,

Thanks for the suggestion. It doesn't seem to work, it freezes excel. I have to try something simpler and break the macro down into smaller pieces, as in find "1" in column F, if there is "1" then run the rest of the macro as a separate sub (macro1), if there is no "1" then run another macro (macro2). Will have to think of proper phrasing.

Regards,
shinobi

[wotadude]

try ....

Please Login or Register  to view this content.