您可以使用
IndentLevel
a的属性
Range
:
Sub Test()
Dim rng As Range, r As Range
Dim indent As Long
Set rng = Sheet1.Range("A1:A10")
For Each r In rng
indent = r.IndentLevel
r.VerticalAlignment = xlCenter
r.IndentLevel = indent
Next
End Sub
使现代化
像
Chris Neilson pointed out
,当您在单元格中循环时,单独更改对齐方式不会影响缩进,而
rng.VerticalAlignment = xlCenter
在整个范围内消除压痕。
因此,这里是迄今为止经过测试的最快的方法(在我的笔记本电脑上运行时为0.41s):
Sub Test()
Application.ScreenUpdating = False
Dim t As Variant: t = Timer
Dim rng As Range, r As Range
Set rng = Sheet1.Range("A1:A10000")
For Each r In rng
r.VerticalAlignment = xlCenter
Next
Debug.Print Timer - t
Application.ScreenUpdating = True
End Sub