Question

vb 如何实现EXCEL两个单元格合并

比如A1=11，B1=22，如何用vb实现c1=11/22
不知如何用VB编程来实现，谢谢

Answer 1

Public Sub MergeCells(tRange As Object)
With tRange

.HorizontalAlignment = -4108 '水平居中excel.XlHAlign.xlHAlignCenter
.VerticalAlignment = -4108 '垂直居中Me.ExcelApp.XlHAlign.xlHAlignCenter '.xlHAlignGeneral
.MergeCells = True
'.xlHAlignGeneral 按照单元数值类型显示’
'.xlHAlignCenter 居中
'.xlHalignLeft ：居左、xlHalignRight：居右、

End With
End Sub

Answer 2

SUB MC_TEST()
[C1]=[A1]/[B1]
END SUB