Vba pass named range to function

Private Sub copyABU()
   Call copyPaste(ThisWorkbook.Names("myRange1").RefersToRange)
   Call copyPaste(ThisWorkbook.Names("myRange2").RefersToRange)
   Call copyPaste(ThisWorkbook.Names("myRange3").RefersToRange)
   ' //etc
End Sub

Source: stackoverflow.com

Similar codes

0 vote460 views1 answer
Excel vba delete columns in range
VBA
0 vote315 views1 answer
How to sort datagridview in vb.net
VBA
0 vote358 views1 answer
Vb streamreader
VBA
0 vote332 views1 answer
Create new worksheet excel visual basic
VBA
0 vote371 views1 answer
Xlbycolumns is not declared
VBA
0 vote363 views1 answer
Show unix time in vba
VBA
1 vote344 views1 answer
Excel vba close form escape key
VBA
0 vote347 views1 answer
Vba line feed
VBA
0 vote373 views1 answer
Rotate image by any angle vb.net
VBA
0 vote362 views1 answer
Excel vba textbox forecolor disabled
VBA