03-16-2017, 10:01 PM
QM in the following code can be streamlined? For example, VBA will use the(with) statement
Ran.Bold = 1
Ran.Font.Size = 15
Ran.Font.Name = "Stencil"
VBA(use with):
With aRange
.Bold = True
With .Font
.Name = "Stencil"
.Size = 15
End With
End With
Ran.Bold = 1
Ran.Font.Size = 15
Ran.Font.Name = "Stencil"
VBA(use with):
With aRange
.Bold = True
With .Font
.Name = "Stencil"
.Size = 15
End With
End With
