在Excel中录制宏,然后根据宏代码来写VC代码
比如合并单元格的宏:
Sub 宏1()
'
' 宏1 宏
'
'
Range("A1:F1").Select
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
Selection.Merge
Range("A1:F1").Select
ActiveCell.FormulaR1C1 = "1234"
Range("F3").Select
End Sub
可以看看宏怎么实现的,改成vc代码还是很容易的