operations on multiple selections

[Guest_imported]

How can I do , in VBA, same operations on multiples selections (cells selected with CTRL )?

 

[kevinclark]

Are you looking for something like this ?

Sub Sample()

For Each Cell In Selection
Cell.Value = "HELLO"
Next Cell

End Sub

 

[acron]

You can use something like

Range("A1:A5,B6:B10,C11:C15&quot.Select, which selects 3 non-contiguous areas, or do it with the Union operator as follows,

Dim oSelect As Range
   Set oSelect = Union([A1:A5], [B6:B10], [C11:c15])
oSelect.Select

A.C.