Creating Tables with Changing Numbers of Rows and Columns

Hi there!

So, I have searched the Internet and cannot seem to find the correct line of code.

I wish to create a program that turns a range into a table. I know the base code--see below. The beginning is my set up, and it is the last line that I am struggling with for right now.


However, I can't seem to figure out how to write the Range so that the Table is only as large as the data in the worksheet. If there isn't a way to do this, then I assume the answer would be to make the entire worksheet a table?

My data is polling data and is constantly changing both in the number of rows and the number of columns. I am trying to find a way to automate reports we write. So the ultimate goal with the table is to use structured referencing to subtotal all of the responses to questions and copy the information into another spreadsheet. I am using Excel 2010. If there is any more information that ought to be provided, let me know!

I am also not sold on doing this as a Table, but since the position of what needs to be counted frequently I figured the table approach with structured references would be my best bet. This is my first major VBA project, and am learning on the fly.

Please Login or Register  to view this content.

Thanks mrice! It worked.