How to access Cell value from specific worksheet in Module of Excel VBA.?

[syparth]

Hello,
I am naive to the Excel VBA.
How to access value of a cell in Module of VBA ?
I tried and it worked - Sheet1.Range("A4").value , but i want to access the Worksheet with its name.
I tried but it did not work - Worksheets("ResultReader").Range("A4").value
I tried but it did not work - Sheets("ResultReader").Range("A4").value

Please suggest me some specific way.

[stnkynts]

If your worksheets name is "ResultReader" then the last two should have worked. Try:

Please Login or Register  to view this content.

[syparth]

When i put a formula of a cell like - "=showSheetName(1)" , the value of the cell becomes like as given below for the perticular line ,

Public Function showSheetName(rownum As Integer) As String

'showSheetName = Sheets("ResultReader").Range("D8").Value -- returns #VALUE
'showSheetName = Sheet3.Range("D8").Value -- Returns proper value of the cell
'showSheetName = (Sheets("ResultReader").Range("D8").Value) -- returns #VALUE
'showSheetName = Worksheets("ResultReader").Range("D8").Value -- returns #VALUE

End Function

Can you please tell me, is there any mistake i have made in the above written code ?