/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 vote212 views1 answer
Excel vba disable screen update
VBA
0 vote236 views2 answers
Vba remove line breaks
VBA
0 vote217 views1 answer
Excel vba join variant array
VBA
1 vote231 views1 answer
Excel vba to lower case
VBA
0 vote246 views1 answer
Excel vba DisplayAlerts
VBA
0 vote239 views1 answer
Vbs run with cscript
VBA
0 vote240 views1 answer
.net dark title bar
VBA
-1 vote261 views1 answer
How to correct a number to 2 decimal places in vba
VBA
1 vote232 views1 answer
Excel vba last row of range
VBA
0 vote249 views1 answer
How to mount floppy disks in vb.net
VBA

Share