/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 vote122 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote118 views1 answer
Show unix time in vba
VBA
0 vote123 views1 answer
Excel vba disable mouse click
VBA
0 vote123 views1 answer
Vbs expand env var
VBA
0 vote127 views1 answer
String contins in vba
VBA
0 vote111 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote110 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote132 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote122 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote122 views1 answer
Excel vba select multiple shapes
VBA

Share