Concatenating two (2) columns

[Jim15]

This is the concatenation macro I have for 2 columns. I want to make this more general in that I would like the program to insert a new column to the right and concatenate the 2 columns based on the current cell the cursor is on and the one adjacent to the left (-1). The loop works fine, the modification I need is for the following three (3) lines.

Please Login or Register  to view this content.

Thanks,

Jim15

[Bob Phillips]

Please Login or Register  to view this content.

[Jim15]

Thanks Mr. Phillips! This works great and I appreciate your assitance.

Jim Williams