/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 vote268 views1 answer
Type excel.application is not defined vb
VBA
0 vote283 views1 answer
Excel vba combine ranges
VBA
0 vote270 views1 answer
Dynamic array vba
VBA
1 vote262 views1 answer
Excel vba get column name from number
VBA
0 vote266 views1 answer
Vba code to open a file with login rights
VBA
11 votes381 views1 answer
Excel vba How to URL encode a string
VBA
1 vote267 views1 answer
Excel vba get ordinal number from cardinal number
VBA
6 votes314 views1 answer
Excel vba check if a string only contains alpha characters
VBA
1 vote310 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote283 views1 answer
Vb ternary
VBA

Share