Hello All,

I have a worksheet with a number of columns that I want to merge, but I want
to keep them in rows. I know how to do one row at a time (highlight the
columns, click the merge button), but as I have several rows this will take
me forever.

I have tried with a macro, but it did not work as expected.

I would appreciate any help to save me time!!!

Regards

Meesha

Select your area and use

Selection.Merge True

You could of course replace Selection with a range of your choosing. I got
it from recording 'Merge across'.

HTH,

Jeff

"Smeesh" wrote in message
...
Hello All,

I have a worksheet with a number of columns that I want to merge, but I
want
to keep them in rows. I know how to do one row at a time (highlight the
columns, click the merge button), but as I have several rows this will
take
me forever.

I have tried with a macro, but it did not work as expected.

I would appreciate any help to save me time!!!

Regards

Meesha