| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I merge entire columns without merging the rows?
I am using Excel to produce report from a VB front end. The report can
contain hundreds of sections and each section has two columns that are merged together. I take a huge perfomance hit by having to merge the cells for each row of data individually, so I would like to be able to select the entire two columns and merge them together at once. However, doing this also merges all the rows together so I get one HUGE cell that spans the entire length of the report. ActiveSheet.Columns(A:B).Merge ' this merges everything Does anyone have any idea how to merge columns without merging the rows too? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging Rows and Columns | Excel Discussion (Misc queries) | |||
| Can I merge rows to columns | New Users to Excel | |||
| How do I convert an entire sheet from columns to rows? | Excel Worksheet Functions | |||
| Using PROPER for Columns, rows or ENTIRE spreadsheet | Excel Worksheet Functions | |||
| Auto update entire columns / rows??? | Excel Worksheet Functions | |||
Threaded Mode
