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

22 votes531 views1 answer
Excelvba check for directory
VBA
4 votes241 views2 answers
Excel vba last column with data
VBA
0 vote177 views1 answer
Excel autofilter vba
VBA
0 vote224 views1 answer
Vb.net round to 2 decimal places
VBA
1 vote233 views1 answer
Vba delete file
VBA
5 votes251 views1 answer
Xlvba double quotes in string literal
VBA
0 vote225 views1 answer
How to set location and size of new from vb
VBA
25 votes529 views2 answers
Excel vba folder exist
VBA
1 vote230 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote237 views1 answer
Excel vba cell on change
VBA