Hi Justin,

Really need more information. If it will help then the following example
loops through the names in a work book and displays their name and address.

Sub Names_Display()
Dim wb As Workbook

Set wb = ThisWorkbook

With wb
For i = 1 To .Names.Count
MsgBox .Names(i).Name & .Names(i).Value
Next
End With

End Sub



Regards,

OssieMac

"JWG" wrote:

I have multiple named ranges on one worksheet and I would like it to
automatically copy each range to a different sheet. Please help.

Thanks

Justin