Thanks davegugg, this function is actually going to be used within a larger macro that performs several other functions with the merged columns, which is why I'm trying to automate the merging with a macro. Thanks.