/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 vote170 views1 answer
Vba html document reference
VBA
0 vote164 views1 answer
Vba find last column in a row with data
VBA
0 vote199 views1 answer
Visual basic run command
VBA
1 vote159 views2 answers
Vba function return array
VBA
0 vote151 views1 answer
Excel protect cells with formulas
VBA
5 votes197 views1 answer
Vba low word from Long Integer
VBA
1 vote169 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote175 views1 answer
VBA Sort RossetaCode
VBA
0 vote174 views1 answer
Vbnet revrese the order of character in string
VBA
1 vote172 views1 answer
Export datagridview to excel vb.net
VBA

Share