Error in a existing Macro used for compare the Comma Separated Values present in 2 columns

Hello Guys,

I need help in removing an error in an existing Macro. I am using a Macro which compares the Comma Separated Values present in 2 different columns.

There are 2 sheets in attached file. In Sheet 1 macro is comparing the comma separated values present in Column C with Column A and if value is same then it will generate 0 and if value is unique then it will generate 1 in Column D. The macro is working fine in Sheet1.

But, if I run the same macro in Sheet2 for same purpose the macro is generating “Type Mismatch - Run Time 13” error.

I need help to modify the macro which works in both conditions either of Sheet1 or Sheet2.

Thanks,
MG

Manish,
You have not got any value in column A to concacnate if the range start from A2

Please Login or Register  to view this content.

Hello AB33,

Thanks for reply.

I had tried to run your suggested Macro but it is throwing result in wrong rows of Volumn D.

Please find the attached file for seeing the result.

Thanks,
MG

MG,
I have not tested the code as you did not have any data to test it on. Please add some output data, so that I can see what is the issue.