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 vote265 views1 answer
Vb.net change cursor to wait
VBA
0 vote256 views1 answer
Vbnet add new ecel sheet
VBA
0 vote260 views1 answer
Open application from vbnet
VBA
1 vote283 views1 answer
Set font for ms chart vb.net
VBA
0 vote264 views1 answer
Vbscript abs
VBA
0 vote270 views1 answer
Vba shape transparent
VBA
0 vote269 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote302 views1 answer
Vba foreach 2d array
VBA
0 vote268 views1 answer
Vbnet line chart showing extra space
VBA
1 vote267 views1 answer
Excel date to unix timestamp
VBA