Question

vb如何设置excel某一个单元格内容居中显示？

请问：vb如何设置excel某单元格的内容居中显示？xlSheet.Cells(1, 1).HorizontalAlignment = xlCenter这样设置不对吗？

Answer 1

很多亩坦东西不会可以先操亏拍作录制一销耐羡个宏，打开看看代码你就会了
Range("F36").Select
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
End With

Answer 2

dim
ex
as
object
dim
exwbook
as
object
dim
exsheet
as
object
set
ex
=
createobject("excel.application")
set
exwbook
=
ex.workbooks().add
set
exsheet
=
exwbook.worksheets("sheet1")
exsheet.cells.horizontalalignment
=
xlcenter
//居腊雀中问题
exsheet.cells.verticalalignment
=
xlcenter
这个问题我也遇到过
我从excel的宏芹唤中得到轮首早了启发
最后搞定了