Macro code for selecting all the data in a table?

[Weaselwithagun]

Hi,

What's the code you need to use in a macro to make it select all the data in a table?

My macro is basically formatting data into a template but is used for several different data dumps. The idea being that the user will dump the data from the system into a sheet, run the macro and the data they need will be put into another tab.

So far this is working well, but I'm trying to work out how to select all the data in the completed tab in one go.

I need it to be able to select all the data in the table, regardless of how big or small the table is, as each time the report is run there will be different amounts of lines.

The first time the report is run it might make a table of 15 lines, the second time it might make 300 lines

is there a way of encoding this into a macro please?

Thanks.

[vcoolio]

Hello WW,

Without seeing a sample of your workbook, we can't be totally sure of which way to go about this but something like:-

Please Login or Register  to view this content.

should work.

"UsedRange" refers to your entire data set.

Cheerio,
vcoolio.