You can use Range("A1").Text
Instead of .Value

sharad

"Hans Weustink" wrote in message
...
No AString is the value of a specific cell, which I want to us to open a
sheet with the same name.

Naming the references is the same as naming the sheet, then the variable
aspect is gone. However could something with cell format (text, with " ",
without " ") have anything to do with it?

Thanks,
Hans

"Sharad Naik" wrote:

This means AString is name of the work book and
not name of the sheet.

Try
AString = "Input"
Sheets(AString).Select '= Will work

Sharad

"Hans Weustink" <Hans wrote in
message
...
Hi,

I'm able to selecet a workbook, but not a sheet based on a reference
like
so:

Sub test()
Dim AString
AString = Sheets("Input").Range("A1").Value

Windows(AString).Activate = works
Sheets(AString).Select = doesn't work
End Sub

Can someone think of a (alternative) way it will work?

Thanks in advance,
Hans Weustink