调试器让我标记我f/ a单元格选择代码

Question

我一直在标记“单元格（newestentry，1）。选择”行。我从使用宏中获得了代码部分，但是它使用了“单元格（A1）。选择”，并且我需要使用坐标才能使用“ newestentry”字符串。我不知道如何解决这个问题？

Dim Tail As ArrayList
Set Tail = New ArrayList

Dim DesiredTail As String
Dim FirstLine As String
Dim NewestEntry As String

   FirstLine = 6
   NewestEntry = Application.WorksheetFunction.Max(Columns("A"))
   
For i = 0 To 20 Step 3 'Tail #/Number of Tails
    DesiredTail = Worksheets("StepBrief").Cells(i + 6, 3).Value
    Tail.Add DesiredTail

Next i

For j = 0 To 3 'Tail Tabs/Number of Tabs

    For k = 1 To 3 '# of Entries to Grab
      
        Sheets(Tail(j)).Select
        Cells(NewestEntry, 1).Select
        Selection.Copy
            Sheets("StepBrief").Select
            Range(FirstLine, 4).Select
            ActiveSheet.Paste
            
        NewestEntry = NewestEntry - 1
        FirstLine = FirstLine + 1

        Next k
        FirstLine = FirstLine + 1
    Next j