Hi Everybody

I have been working on two macros, and this step of the work I have to:

1- Edit the the Stock_Info macro in the Visual Basic Editor, adding a
line at the beginning of the macro that retrieves the value from the active
cell and stores it in a variable named "Stockname." (Hint: Use the Value
property of the ActiveCell object.) Edit the macro firther so that it opens
the worksheet referenced by the Stockname variable.

2- Test the macro by clicking a ticker symbol in the Stock List
worksheet and pressing Ctrl+t. Verify that the macro displays the worksheet
for that stock. Also test pressing Ctrl+m takes the user back to the Stock
List worksheet.

With what I tried I just got Run-time errors I will appreciate it if
anybody helps me to successfully continue with these two macros. Also, is
there anywhere I could learn more about the Value property of the ActiveCell
object?
Thank you in advance.

Sub Stock_Info()
'
' Stock_Info Macro
' This macro displays the AA worksheet, then selects cell C2.
'
' Keyboard Shortcut: Ctrl+t
'
Sheets("AA").Select
Range("C2").Select
End Sub
Sub Stock_List()
'
' Stock_List Macro
' This macro displays the Stock List, then selects cell A1.
'
' Keyboard Shortcut: Ctrl+m
'
Sheets("Stock List").Select
Range("A1").Select
End Sub