Hi all,
Quick question: When using "With" is it possible to specify 2 ranges, or will I need to do 2 different with blocks? The reason I say not using Union is because I need my ranges seperate. I run 1 set of commands on Range 1, and 1 set of commands on both Range 1 and 2.
e.g. ...
With multirangew
.Locked = False
.ClearContents
End With
With multirangew And qrangew
.Interior.ColorIndex = 2
.Interior.Pattern = xlSolid
.Interior.PatternColorIndex = xlAutomatic
End With
Is this possible by other means, or will I have to do 1 "With" for multirangew and then a duplicate "With" for qrangew?
Cheers,
Bob
Bookmarks