I just need a way of producing a list of tab's into a series of cells ..

One way is to install/run this sub on a new sheet
The list of tabs will appear in A2 down

Sub ListSheetNames()
Dim wkSht As Worksheet
Range("A2").Select
For Each wkSht In Worksheets
Selection = wkSht.Name
ActiveCell.Offset(rowOffset:=1, columnOffset:=0).Activate
Next wkSht
End Sub

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---