Loop Through Named Range / Save Copy As

[marka87uk]

Hi,

I have a list of categories named Categories - it contains about 100 different types.

What I'd like to do is loop through each category, firstly setting the contents of a cell (say A2) to the category name, and then saving a copy of workbook with that category name in the file title.

Can anyone help please?

 

[marka87uk]

Cheeky bump, sorry...

I'm fine with saving a copy of the file and setting the cell value, I'm just a little lost on looping through the named range.

Many thanks.

 

[marka87uk]

I got it working in the end and it was much simpler than I realised...

Here is the solution to help anyone else who stumbles upon this page!

Dim Category As Range
For Each Category In Range("Categories")
Range("B4").Value = Category
Next Category