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 vote170 views1 answer
How to sort datagridview in vb.net
VBA
0 vote214 views1 answer
Afficher un message d'erreur vba
VBA
0 vote226 views1 answer
Vba open report
VBA
0 vote219 views1 answer
Dynamic array vba
VBA
5 votes215 views1 answer
Excel vba low byte from INTEGER
VBA
0 vote217 views1 answer
Vba get workbook name
VBA
1 vote215 views1 answer
Vb.net get name by Cell Click
VBA
5 votes237 views1 answer
Excel vba first byte from INTEGER
VBA
1 vote221 views1 answer
Vba refresh pivot table
VBA
1 vote221 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA