/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 vote197 views1 answer
Add items to combobox vb.net
VBA
0 vote200 views1 answer
Vba get text file content
VBA
0 vote226 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote191 views1 answer
Vba first cell in range
VBA
2 votes211 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote194 views1 answer
Quit excel with save changes dialog vb.net
VBA
1 vote204 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote193 views1 answer
Vba createparameter null
VBA
5 votes227 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote231 views1 answer
Vba vbcrlf chr
VBA

Share