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 vote173 views1 answer
Excel vba disable screen update
VBA
0 vote142 views1 answer
Vbide vbproject reference
VBA
2 votes181 views1 answer
Excel vba check if key is in collection
VBA
0 vote190 views1 answer
Vba apostrophe chr
VBA
5 votes196 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote215 views1 answer
Excel vba round to whole number
VBA
2 votes170 views2 answers
Constructor vb.net
VBA
0 vote209 views1 answer
Excel vba protect shapes
VBA
0 vote214 views2 answers
Checking and changing system volume vb.net
VBA
0 vote180 views1 answer
Handling a click event anywhere inside a panel vb
VBA