Selecting worksheet when naming a workbook

[louisepr]

Hi. Hopefully this is an easy one for someone to help me with

My current code is

Workbooks.Open LTN
LTN = ActiveWorkbook.Name
lastrowLTN = Cells(Rows.Count, "a").End(xlUp).Row

however, this file contains multiple sheets. Am I able get LTN to reference a particular worksheet ("Result_Set") instead of the first sheet whenever I use Workbooks(LTN).Activate?
Thanks in advance

 

[eduzs]

Sheets(X). (by number/position) or Sheets("Name") (By name).

 

[louisepr]

Thank you . Where would I put that in the code above?

 

[eduzs]

Sheets("Result_Set").Cells(Rows.Count, "a").End(xlUp).Row

 

[louisepr]

aah. of course. Thanks you so much!

 

[eduzs]

You're welcome.