How to use non-contiguous range of cells in Excel VBA

Submitted by Support on Sun, 02/22/2009 - 11:55

Here is a way to update a range that is not contiguous using VBA

Sub NonContiguous_Range_Example()

Dim oRng As Range

Set oRng = Range("A1, B5, C9")

oRng.Value = "45"

oRng.Interior.ColorIndex = 34

End Sub

The output will be as shown below: