Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to merge cells
Please a macro to merge cells of course codes based on
duration of course. For example the 3 cells of PM 01 in the first row shoud be merged and only one PM 01 centered in the cell covering 31 Jul to 2 Aug. Table 1: Course Duration Course Duration HR 12 1 IM 01 3 MM 01 2 PM 01 3 Table 2 Courses Shedule 31-Jul-04 1-Aug-04 2-Aug-04 3-Aug-04 4-Aug-04 PM 01 PM 01 PM 01 PM 01 PM 01 PM 01 PM 02 PM 02 PM 02 PM 02 PM 02 PM 02 HR 12 HR 12 HR 12 HR 12 HR 12 HR 12 HR 12 HR 12 HR 12 HR 12 IM 01 IM 01 IM 01 IM 01 IM 01 IM 01 MM 01 MM 01 MM 01 MM 01 MM 01 MM 01 MM 01 MM 01 MM 01 MM 01 MM 01 MM 01 MM 01 MM 01 MM 01 MM 01 MM 02 MM 02 MM 02 MM 02 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I merge cells into one then delete the original cells? | Excel Worksheet Functions | |||
Merge cells with formula or macro? | Excel Discussion (Misc queries) | |||
Excel Macro - Merge Cells unavailable - Unable to figue out why. | Excel Worksheet Functions | |||
Merge Cells in a column Macro | Excel Programming | |||
Merge cells using macro | Excel Programming |