Re: merge cells

Giganews Newsgroups
Subject: Re: merge cells
Posted by:  Frank Isaacs (fra…
Date: Wed, 8 Oct 2003

You'll need to write a macro to do this; I don't know of any shortcut.

First, make a backup of your spreadsheet. Then, record the actions you do
for one pair of cells being merged, and stop the macro recorder. Then
examine the code and make it more general so it can go across a whole row of
your data and be included in a For...Next loop. Then enclose that code in
another For...Next loop to go down to row 256, doing the same thing.

For help with the macro itself, best place to post is in the .programming
group once you get started. (Post the actual code that's not doing what you


-Frank Isaacs
Dolphin Technology Corp.

"herman" <herman.valc…> wrote in message
> how can i merge the info on a large spread sheet quickly
> without having to do this one cell at a time.
> I have info in cells A1 thru HH1,A3-HH3,A5-HH5 and so on
> I need this info to be merged with the cell directly below
> it
> In other words I need cell A1 to be merged with A2,B1 with
> B2....A3 with A4,A5 with A6 ....HH5 with HH6 with our
> losing the info in the cells,
> whats the simpliest and fastest way to do this with out
> having to click on cell, hold shift key, down arrow,
> merge cell button, right arrow, hold shift key,down arrow
> key, merge button  or format painter on completed a merged
> cell, right arrow button, click format painter and repeat,
> there's got to be an easier way I have cells AB18-HV18 down
> to row 256 to do this to  help me i'm getting carpal tunnel
> syndrome.  thanks in advance
>                              Herman



In response to

merge cells posted by herman on Wed, 8 Oct 2003