Referencing to named cell on different worksheet

[Willem!]

Hi, When I reference (in code) to a named cell on a different worksheet something goes wrong. When I use the following code, everything works fine:

Sub cmdButton_Click()
Dim dblNumber As Double
    dblNumber = Sheets("Birdie").Range("wbet").Value
    MsgBox dblNumber
End Sub

But when I use the following, I get an error:

Sub cmdButton_Click()
Dim dblNumber As Double
    dblNumber = Sheet20.Range("wbet").Value
    MsgBox dblNumber
End Sub

So when I replace 'Sheets("Birdie").Ran....' with 'Sheet20.Ran...' the error arises. I want to use the second line of code, because that's more flexible (users can alter the sheetname in that way).

What am I overseeing?

 

[onlyadrafter]

Hello,

try

SHeets("Sheet20").range("wbet").value

 

[Willem!]

Hi,

That's doens't work because your code suggests that "Sheet20" is the name of the sheet, which is not the case (it's name is Birdie, but it is Sheet20)

 

[cornflakegirl]

onlya - I think that Sheet20 is the codename of the sheet called Birdie, so I don't think that would work?

Willem - your code works okay for me.

 

[Willem!]

Oi!

I am a very silly man, I tried to reference to Sheet20 whereas the named call was located on Sheet15.

Thank you guys for your help!