/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

1 vote154 views2 answers
Get all column names from excel vba
VBA
3 votes159 views1 answer
Excel vba get the workbook full file name with path
VBA
1 vote114 views1 answer
How to open cmd with vbd
VBA
0 vote200 views1 answer
Vbnet add axis labels to chart
VBA
5 votes105 views1 answer
Vlookup vba
VBA
0 vote106 views1 answer
How to sort datagridview in vb.net
VBA
0 vote177 views1 answer
Vba registry settings
VBA
0 vote175 views1 answer
Excel vba open browser
VBA
0 vote169 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote161 views1 answer
Excel vba prevent saving workbook
VBA

Share