Macro to change the only table on worksheet, without specifying worksheet name

[taylorsm]

I have a log that I use monthly and a macro that inserts a new row into my log's table. New month = new log and new worksheet. But now my macro will not work because it wants to change last month's table. Manually changing the name of the table reference in the macro isn't hard, but is there an easier way? This is the macro I use.

Please Login or Register  to view this content.

[Tsjallie]

You can refer to a table by it's index.
If it's the only table on the sheet that's active then your refer at with
[fomula]ActiveSheet.ListObjects(1)[/formula]

[taylorsm]

Thank you!