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

5 votes221 views1 answer
Excel vba low byte from INTEGER
VBA
0 vote259 views1 answer
Excel vba paste all to each sheet in workbook
VBA
1 vote209 views1 answer
Excel vba unload userform
VBA
0 vote219 views1 answer
Arq linux
VBA
3 votes241 views1 answer
Extract word in a text in excel
VBA
0 vote213 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote217 views1 answer
Vba paste values
VBA
3 votes242 views2 answers
Vba date to string
VBA
0 vote226 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote224 views1 answer
Remove first character from string vb
VBA