/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 vote117 views2 answers
Excel vba copy paste after last row
VBA
0 vote127 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote135 views1 answer
Vbnet line chart showing extra space
VBA
1 vote127 views1 answer
Vba delete array element
VBA
0 vote138 views1 answer
Vba loop through textboxes
VBA
1 vote144 views1 answer
Export datagridview to excel vb.net
VBA
8 votes251 views1 answer
Vba make a short integer from two bytes
VBA
0 vote134 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote126 views1 answer
Vba text to general
VBA
0 vote126 views1 answer
Vba add shape oval
VBA

Share