Selecting Cell to Jump to other sheets (macro, no hyperlink)

[DavidWood]

Hi, I am using Excel 2007 and I'm trying to run a macro to do the following:
Once a certain cell is selected, I want to jump to another sheet, but without using a hyperlink. I have a list of job #'s in a column and i want each one of the job #'s to be linked to its own individual page and cell. Here is my macro thus far:

Sub Move_Cursor_Appropriate_Account_Number()
   
    For I = 2 To Sheets.Count
    For CountRow = 1 To I - 1
    RowC = Row + CountRow
        If Worksheets("Sheet1").Cells(RowC, 4).Select Then
           Worksheets(I).Activate
           Range("B2").Select
        End If
        Next
        Next

End Sub

The error that came up stated "unable to get the select property of the range class"
I also tried using selection.address, but I couldn't figure out how to incorporate a variable length of a column.

 

[ylostword]

Reply

Dear i have this same problem but i don't get this answer from any buddy .that is the reason i am just posting here for know it's answer.....

Consumer Court

 

[DavidWood]

haha, great