Select specific cell once worksheet opened

[ipbr21054]

Hi,

Im using the code below to open another workbook sheet then have the cell B51 selected but getting a compile error
Just using the FollowHyperlink line of code works fine but then im unable to select the cell in question

Private Sub KDX2Folder_Click()
ActiveWorkbook.FollowHyperlink ("C:\Users\Ian\Desktop\REMOTES ETC\DR\EXCEL WORKSHEETS\CLONING-KDX2.xlsm")
With ("KDX2LIST")
Range("b51").Select
End With
End Sub

 

[rollis13]

Shouldn't it be:

With Sheets("KDX2LIST")

 

[ipbr21054]

Hi,

If you mean like this below that then give me RTE 1004 Range class failed

Private Sub KDX2Folder_Click()
ActiveWorkbook.FollowHyperlink ("C:\Users\Ian\Desktop\REMOTES ETC\DR\EXCEL WORKSHEETS\CLONING-KDX2.xlsm")
With Sheets("KDX2LIST")
Range("B51").Select
End With
End Sub

 

[Peter_SSs]

Does this do what you want?

Private Sub KDX2Folder_Click()
  ActiveWorkbook.FollowHyperlink ("C:\Users\Ian\Desktop\REMOTES ETC\DR\EXCEL WORKSHEETS\CLONING-KDX2.xlsm")
  Application.Goto Workbooks("CLONING-KDX2.xlsm").Worksheets("KDX2LIST").Range("B51"), True
End Sub

 

[ipbr21054]

It does many thanks

Have a nice day

 

[Peter_SSs]

You are welcome.