If not empty do not do macro

Good morning,
I have 2 macros that work more or less well but I have a problem that I would like to have more "professional working". So I have a macro that copy 2 columns range to other cell as values that is named "Sub copy_details". The problem is that when I run other macro does not recognizes "" as totally empty and the sort is not correct. So I did other macro to clean the "" at the "J" column cells and pass to empty, that it's named "clean_cells_to_empty". The problem is that sometimes does not find cells with "" and appears the error to debug or end macro. What code could I add for in case does not find cells with "" at "J" column, does not do the macro. Shoud be easy to people who knows about this. Thank you very much in advance.

Please Login or Register  to view this content.

bye for now.

BR,
Pedro

Hi there,

This is difficult to test properly without access to your workbook, but see if the following code does what you need:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M

Fantastic Greg,
Works like a charm. And what I thought form your macro is that instead having 2 macros "copy_details" and "clean_cells_to_empty", as it can test it before to check empty cells or not, I'm going to include all in the same macro that will be "copy_details". Thank you Greg once again I comment also your rep.

Hi again,

Many thanks for your very prompt feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M