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

8 votes204 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote128 views1 answer
Average vba
VBA
0 vote121 views1 answer
Vbs
VBA
0 vote80 views10 answers
Vba excel create event log
VBA
4 votes76 views2 answers
Vba last row
VBA
8 votes115 views1 answer
Excel vba make a short integer from two bytes
VBA
20 votes253 views1 answer
Excel vba recursive example factorial function
VBA
0 vote124 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote130 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote123 views1 answer
Get current url vb.net
VBA