Hi, i'm new to VBA coding. The situation is that I have a file that comes in every week with the same number of column, but with different number of rows [i.e. one week the data have 50 rows, another might have 200 etc...]. I would make a table [ctrl L] that consist of the entire data set and name it 'X' to do further analysis.

Lets say if the column is always from A to Z, and I always want to name the table 'X', how would i write a macro for that?

So far all I got from reference books is:

Sub Test()
Range(ActiveCell, ActiveCell.End(xlDown)).Select
End Sub

Please provide an example on how to do this [and please explain the reasoning behind the example if possible, I am new to VBA and have no prior programming experience]