VBA using rows.count from another sheet

[DataBlake]

Sub Macro1()
'
' Macro1 Macro
'

'
Sheets("Unknown").Select
Dim lastRow As Long
lastRow = Range("A" & Rows.Count).End(xlUp).Row
Sheets("Sheet1").Select
Rows("2:2").Select
Range("2:2").AutoFill Destination:=Range("2:2" & lastRow)



End Sub

is what i have, but when i ran it "Sheet1" autofilled to 25 rows vs the 5 rows in "Unknown"
i thought i had a good handle on lastrow, but apparently not.
any help would be greatly appreciated.

 

[Akuini]

Maybe this:

Range("2:2").AutoFill Destination:=Range[COLOR=#0000cd]("2:"[/COLOR] & lastRow)

 

[DataBlake]

Maybe this:

Range("2:2").AutoFill Destination:=Range[COLOR=#0000cd]("2:"[/COLOR] & lastRow)

well would you look at that
thank you for your help

 

[Akuini]

You're welcome.