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
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