VBA Change Sheet Name Reference

[FalconFlyer]

Hopefully this is something simple I'm overlooking. I am using the code below to find the last row in another workbook. It works fine, but I would like to change it to reference the Worksheet "Sheet1", not the name of the Worksheet. I do not want problems down the road if someone changes the name. I have tried to change the code, but I cannot figure it out. If anyone can point me in the right direction, that would be helpful.

TIA

LastRow1 = wkbk.Sheets("Master Summary List").Cells(wkbk.Sheets("Master Summary List").Rows.Count, "A").End(xlUp).Row
wkbk.Sheets("Master Summary List").Cells((LastRow1 + 1), "A") = txt

 

[Fluff]

How about

   For Each ws In wkbk.Worksheets
      If ws.CodeName = "Sheet1" Then Set mws = ws
   Next ws

 

[JoeMo]

Untested, but I think this should work:

With WkBk.Sheet1
    LastRow1 = .Cells(.Rows.Count, "A").End(xlUp).Row
    .Cells((LastRow1 + 1), "A") = txt
End With