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
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