Retrive a value from another worksheet in the same workbook

[Guest]

Hi all again,
I was trying to do what the subject said. I used:

Application.Goto Sheets("Requirement").Range(cell_Name)

I found this code in Microsoft MSDN, but... seems it is not working...

What I wanted to do was, eg. on the sheets("Selections"), cursor is on one
of the cell. Retrive the name of the cell, and goto the sheets("Requirement")
to find a value equals to cell_Name. All values in sheets("Requirement") are
unique. I want it done without using sheets("Requirement").Activate. i.e. not
physically changing the worksheet and get the value and get back to
sheets("Selection").

Do you guys understand what I am trying to say?! I wish you can understand
it... :'(

Ray

 

[Guest]

Oops, I found the way now:
requirements = Sheets("Requirement").Range(req_name).Offset(0, 1).Value

Sorry for opening and close the post by myself. LOL

Ray