alternative to Select/activate - to delete all data in a worksheet

[ItalianPlatinum]

Hello - i am trying to improve my VBA and speed it up by removing all instances of select and activate. one issue i am having is converting the below:

Workbooks("t.xlsx").Activate
sheets("main").Activate
Range("A2:X2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Delete
ActiveWorkbook.Close SaveChanges:=True

i thought this would work but it doesn't seem to be:

Workbooks("t.xlsx").sheets("main").Range("A2:X2").End(xlDown)).Delete
ActiveWorkbook.Close SaveChanges:=True

 

[Fluff]

How about

With Workbooks("t.xlsx").Sheets("main")
   .Range("A2:X" & .Range("A" & Rows.count).End(xlUp).Row).Delete
End With

 

[ItalianPlatinum]

How about

With Workbooks("t.xlsx").Sheets("main")
   .Range("A2:X" & .Range("A" & Rows.count).End(xlUp).Row).Delete
End With

would this still work if i had to open the workbook?

With Workbooks.open("t.xlsx").Sheets("main")
.Range("A2:X" & .Range("A" & Rows.count).End(xlUp).Row).Delete
End With

 

[Fluff]

You have to open the workbook to delete the cells.

 

[ItalianPlatinum]

ok understood so then the below will work and seems to be

Workbooks.open(fromPath & "t.xlsx")
With Workbooks("t.xlsx").Sheets("main")
.Range("A2:X" & .Range("A" & Rows.count).End(xlUp).Row).Delete
End With

 

[Fluff]

That should be fine

 

[ItalianPlatinum]

ok understood so then the below will work and seems to be

Workbooks.open(fromPath & "t.xlsx")
With Workbooks("t.xlsx").Sheets("main")
.Range("A2:X" & .Range("A" & Rows.count).End(xlUp).Row).Delete
End With

so its actually deleting my top row. where I want it to delete everything below from A2 to X2 down

 

[Fluff]

That would suggest that col A is empty.
What column will always have data?

 

[ItalianPlatinum]

That would suggest that col A is empty.
What column will always have data?

A1:X1 will always have a header, and the data will start on A2:X2, and that is what i am trying to delete

 

[Fluff]

Yes but which column will always have data on the last row?