I notice that some instructions in my macros can be shortened, thereby saving nanoseconds of running time (presumably !), and the end result of the operation is still the same.
But is it so? Are there any drawbacks? is the time saved worth it, when I have to run many such instructions?
Some instances:
1)
Range("C2").Select
Selection.Copy
shortened to
2)
Range("C2").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 65535
.TintAndShade = 0
.PatternTintAndShade = 0
End With
shortened to
Range("C2").Interior.Color = 65535
3)
Cells.Find(What:="2", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
shortened to
Cells.Find(What:="2", After:=ActiveCell, LookAt:=xlPart, searchOrder:=xlByColumns, SearchDirection:=xlNext).Activate
Thanks for any enlightened answer.
ACA
Bookmarks