Find last row and drag down

[VBAtor]

Hi,

Im trying to get this to work. Im using code to count last row in A column starting from A" and then based on that number drag down to matching row in the active sheet (XML2).

So if the number of rows in A is 250 then it should drag down A2:X250.

I have enclosed my code for reference.

Dim lRow As Long

lRow = Worksheets("SE").Cells(Rows.Count, 1).End(xlUp).Row



Sheets("XML2").Select
Range(Range("a3"), Selection.End(xlDown)).Select
Selection.ClearContents

 Range("A2:X2").Select
  Selection.AutoFill Destination:=Range("A2:lrow"), Type:=xlFillDefault

Any ideas?

Kind regards,
VBAtor