Merging a number of rows

S

Smeesh

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
 
J

Jeff Standen

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
 
Top