VBA code to exclude cells that are blank

Hi everyone,

I currently have a code that for combines cells within a range together and places them into another cell.

I want the code to only include cell that have a value in and exclude those within the range that are blank.

I have included the code below:

Please Login or Register  to view this content.

hi msmithy,

Please Login or Register  to view this content.

Thank you. It worked a treat.

I can now say this is solved.