/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 vote284 views1 answer
Vba leading zeros in string
VBA
0 vote300 views1 answer
Excel vba prevent saving workbook
VBA
0 vote276 views1 answer
Excel vba scroll to cell
VBA
0 vote414 views1 answer
Amd64 vs arm64 linux
VBA
3 votes290 views1 answer
Vba not equal
VBA
0 vote263 views1 answer
Excel vba existence of a file
VBA
-1 vote274 views1 answer
For i in range vba
VBA
1 vote281 views1 answer
Excel date to unix timestamp
VBA
0 vote260 views1 answer
Excel vba milliseconds
VBA
0 vote282 views2 answers
Excel vba protect cells with formula
VBA

Share