Concatenate using Excel VBA with variable column numbers

Hi All,

I am working on a reconciliation wherein I need to pass 2 sets of data through several sets of parameters in order to identify the possible match. In order to do that for each row I need to concatenate 8-11 columns which should be variable in nature based on the data provided in the sheet (Concatenate).

I am using the below macro to populate the concatenated data in Sheets (Data), however I am getting an error "Application-defined or Object-defined error".

Attaching the excel spreadsheet with the data and codes. Please help me in sorting this out.

Regards,
Raghu

Hi Raghukumarn,

You needed to "cap the end" of your formula with a ")".

Put this just after the Loop command:

Please Login or Register  to view this content.

Hope it works for you.

Cheers