Excel 2003 Cell X1 Y1 merge.

[Astro]

Hello there,

I have a list of excel columns to present my questionnaire questions.
note: ms excel 2003.

for eg, i have two columns x and y. at the first cell of each column, a label is required. unfortunately column x and y are to share a single label, i would like to merge the first cell of each column into a single cell in order to accomodate the one particular label.

e = 152
g = 400
 
 For i = 0 To UBound(resultString)
                     '   .Checkboxes.Add(g, e, 80, 10).Text = d
                     
                     
                     Set chk = .Checkboxes.Add(g, e, 80, 10)
                        chk.Text = d
                        chk.Name = "Q" & h & "chkbox" & chkbox & "Ans" & An
                        
                        .Cells(k, 25).Formula = chkbox
                        
                        g = g + 50
                        chkbox = chkbox + 1
 Next
                    
                End If
                    
                e = e + 12.5

_________
| |
| L a b e l |
|________|
| X | Y |
|---------|
| 1 | 2 |
|---------|
| 3 | 4 |
-----------


Astro

[Ecniv]

have the sheet ready.
Tools>Macro>record
(got through until it is ready to record your clicks)
Select the two cells.
Cell Format.
Change to merge cells and any other options/colours.
Stop recording.
Check the code and change it (subtly) to fit with your code.