/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 vote191 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
-1 vote196 views2 answers
Excel vba delete empty rows
VBA
0 vote173 views1 answer
Excel vba disable screen update
VBA
0 vote185 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote197 views1 answer
Vbnet click on dgv cells
VBA
0 vote197 views1 answer
Return na vba
VBA
0 vote185 views1 answer
Vba boolean to string
VBA
0 vote179 views1 answer
Change whcih control a user has selected vb
VBA
0 vote134 views1 answer
How to sort datagridview in vb.net
VBA
0 vote204 views1 answer
How to make a a msgbpx in vbs
VBA

Share