/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 vote173 views1 answer
Vba count all row
VBA
0 vote159 views1 answer
Vbs write file
VBA
0 vote142 views1 answer
Vba dropdown event
VBA
3 votes157 views1 answer
Vba request json
VBA
0 vote162 views1 answer
Vba range clear formatting
VBA
0 vote163 views1 answer
Vba sort multiple columns
VBA
0 vote155 views1 answer
Returns an array from function vba
VBA
0 vote163 views1 answer
Vba format currency
VBA
0 vote102 views1 answer
Vba select file in folder
VBA
0 vote155 views1 answer
Vba shape transparent
VBA

Share