/VBA/VBA Loop to range

VBA Loop to range

VBA Loop to range

Dim rng As Range: Set rng = Application.Selection
Dim rngArea As Range
For Each rngArea In rng.Areas
    Debug.Print rngArea.Address
Next rngArea

0

Source: codevba.com

Similar codes

0 vote252 views1 answer
Prive sub enter clicked vb
VBA
0 vote231 views1 answer
Do while not vb.net
VBA
8 votes312 views1 answer
Excel vba make word
VBA
5 votes239 views1 answer
Xl vba double quotes in string literal
VBA
0 vote283 views1 answer
VBA is form loaded
VBA
0 vote238 views1 answer
Vba shape transparent
VBA
0 vote229 views1 answer
Excel vba disable copy paste
VBA
5 votes273 views1 answer
Excel vba how to unit test vba code
VBA
0 vote240 views1 answer
Rotate image by any angle vb.net
VBA
0 vote239 views1 answer
Excel vba linter
VBA

Share