Dear all,

Is it possible to add new worksheets and then rename them based on vlookup values?

I have been trying this but it doesn't seem to work:

Dim i As Integer
Dim j As Integer

For i = *User predefined number*

Sheets.Add After:=Sheets(Sheets.Count)
j = j + 1
'Name Sheet according to Segments List
Sheets("Sheet" & j).Name = Application.WorksheetFunction.VLookup(i, Sheets("Dashboard").segmentsdata, 2, 0)

So my named range "segmentsdata" is in another sheet.

Is it possible at all to do this?

Thanks in advance!

Shane