Quick VB function question

[jferri]

Quick Question.

In the below function, if "symbol" is the name of various worksheets in my workbook, why is the following function not working?

Thanks!


Public Function theValue(symbol As Variant)

theValue = Sheets(symbol).Cells(1, 5).Value

End Function

 

[Greg Truby]

That works for me. Though I would cast symbol as a String and not a variant.

 

[Richard Schollar]

Try specifying symbol as a string rather than a variant - otherwise if the sheet name is a numerical value (like say '10') the function will actually look for the sheet in the activeworkbook with an index value of 10 rather than a name of '10'.

Richard

 

[GlennUK]

It works for me. In what way doesn't it work for you?

 

[jferri]

cool. it looks like i was being sloppy, and impatient. just needed to wait a bit longer.

thanks for the reply.