How can I select data to the end of a range in a macro?

I want my macro to always select all the data in a range. The problem is if I specify a range it will always select that exact range, not the data itself. I've tried converting it to a table but the same problem occurs, it will always do the same range of cells instead of the actual data.

Hi,
Here is a good example, it looks like when it comes to the selection, maybe it is selecting to the end of the data, but when it does the command to format the selection as a table it explicitly does the range in the example file I used to setup the macro. I think what needs to be edited is the Range() parameter in the .Add section that creates Table1:

Please Login or Register  to view this content.

No, I'm not trying to select the table, here I am creating the table. I select to the end of the data and then click format as table, but the macro interprets that as converting a literal range. The next time I run this macro on a file it will convert A1 to F120 to a table instead of all the data. I think I need to replace Range("$A$1:$F$120") with something that would always capture the entire range.