How to use defined range name in loop

Hi Robert

Thanks for getting in touch. Yes this can be done. You'll need code like this:

Sub RangeNameInLoop()

Dim c As Range
Dim Rng As Range

Set Rng = Range("Manufacturer")

For Each c In Rng

Sheets.Add
ActiveSheet.Name = c.Value

Next

End Sub

It's fairly straightforward, but if you'd like me to clarify any part of it let me know.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector