通俗点讲with的作用就是简化代码,让代码简洁易懂
让你不需要输入重复的内容
.RowHeight = 10
.ColumnWidth = 15
[A1].RowHeight = 10
[A1].ColumnWidth = 15
让你不需要输入重复的内容
例如:
With [A1].RowHeight = 10
.ColumnWidth = 15
End With
[A1].RowHeight = 10
[A1].ColumnWidth = 15
省去了输入很多[A1]