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 vote127 views1 answer
Vbscript for loop
VBA
0 vote134 views1 answer
Excel R1C1 mode
VBA
31 votes237 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
5 votes160 views1 answer
Excel vba get user selected range
VBA
1 vote979 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote129 views3 answers
Write to text file vb.net
VBA
5 votes153 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote125 views1 answer
How to extract a file from an ISO:
VBA
0 vote135 views1 answer
Rotate image by any angle vb.net
VBA
0 vote124 views1 answer
Excel vba concatenate range
VBA