VBA to select table in Active Sheet

[jbvinny]

I am trying to convert a table to a range using VBA or in otherwords 'unlist' the table. The code I have works for the most part. The problem is the table name changes from day to day. Does anyone know a way to select the table on the active sheet regardless of that tables name? There is only one table per sheet.

 

[RoryA]

Activesheet.listobjects(1)

should do it.

 

[jbvinny]

Perfect! I expected to find the answer pretty easily with a web search but it was no where. Appreciate the help.