Posted to microsoft.public.excel.misc

Joe M.

external usenet poster

Posts: 97

Merge cells with formula or macro?

I would like to merge cells in column A when the adjacent vertical cells are
the same. For example:

Col A
Row1 CX457
Row2 AG925
Row3 AG925
Row4 AG925
Row5 RB639
Row6 RB639

In this case A2, A3 & A4 would be merged, A5 & A6 would be merged. Is there
a way to do this automatically?

Thanks,
Joe M.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to run formula only on cells with data	Rob	Excel Discussion (Misc queries)	4	March 5th 07 07:05 PM
Formula in macro or in sheet/cells?	Heine	Excel Worksheet Functions	10	November 3rd 06 11:02 PM
Merge =( formula should retain fraction type numbers after merge.	Aubrey	Excel Worksheet Functions	0	February 9th 06 07:37 PM
Excel Macro - Merge Cells unavailable - Unable to figue out why.	newexceluser	Excel Worksheet Functions	0	January 18th 06 03:22 PM
repeat macro formula to all cells	dave glynn	Excel Discussion (Misc queries)	8	March 10th 05 08:42 PM

All times are GMT +1. The time now is 02:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us