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:
Showing posts with label Update non-contiguous ranges using VBA. Show all posts
Showing posts with label Update non-contiguous ranges using VBA. Show all posts
Sunday, February 22, 2009
How to use non-contiguous range of cells in Excel VBA
Subscribe to:
Posts (Atom)
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.
Posts
