/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 vote373 views1 answer
VB Error Code BC30201
VBA
2 votes354 views1 answer
Excel vba check if string entirely numeric
VBA
22 votes521 views1 answer
Xlvba check for folder
VBA
0 vote361 views1 answer
Openfiledialog specific folder
VBA
0 vote377 views1 answer
Excel vba protect content
VBA
32 votes561 views2 answers
Excel vba column letter
VBA
0 vote349 views1 answer
Dlete rows with blanks and space " " vba
VBA
2 votes354 views1 answer
Vba split string
VBA
0 vote370 views1 answer
Vba loop through textboxes
VBA
1 vote415 views2 answers
Vba find last row in range for certain criteria
VBA

Share