Hi all,

I have a workbook that adds worksheets, names them and sorts them. I need to
show these worksheets as Sheet 1 of 1 and if necessary Sheet 1 of 2 and Sheet
2 of 2. When it adds the worksheets it names them based on a cell entry, so I
will have something like: DBL ARROW for worksheet1 name and it would be Sheet
1 of 1, if I need another sheet with the same name it would be DBL ARROW (2).
So I would now want DBL ARROW to be Sheet 1 of 2 and DBL ARROW (2) to be
Sheet 2 of 2, then if I added another sheet named 4" Yellow it would be Sheet
1 of 1 and so on. Is there a way to do this? I have ranges named Sht_of_ and
Sht_of_1 for the numbers.