I assume that you have more than just Sheet2 to put its name into A1 of
START. In this case you shouldn't use macros in each sheet. I think it would
be better to put something like

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Sh.Name < "START" Then Worksheets("START").Range("A1") = Sh.Name
End Sub

into the code section of ThisWorkbook. This will put the sheetname of
whatever sheet is activated (except the START sheet itself) into A1 of
START. NickHK already showed you how to use the resulting text for your
code.

Cheers,

Joerg

"johan" wrote in message
oups.com...
Thanks, works fine.

Another supplemental question....

Now the last used sheet (with the above mentioned registrationmacro)
is registrated in sheet "Start" cell A1.
Question...
How to open on a different sheet, without the above mentioned
registrationmacro, the sheetname that is registrated in sheet "Start"
cell A1.

For example....
In sheet Start cell A1 last used sheetname "Sheet2" is registrated.
Now I'm in sheet 10 and with a macro I want to open the sheetname that
is registrated in sheet "Start" cell A1.

thanks a lot,
regards.... Johan