Macro with Reference to Dynamic Table Name

[damckinley80]

I struggle with writing/recording/editing macros based on dynamic information.

I am trying to create a macro that performs the following:

• Unprotect active sheet
• Locate column 'Item' in table on active sheet
• Filter blank cells in column 'Item'
• Export print area to a user selected path and user defined file name
• Unfilter column 'Item'
• Protect active sheeet

Recording the macro on the active sheet is not the problem. The problem is that the worksheet will be copied and the table on the copied sheet will default to a new name, nullifying the macro on that particular sheet as the original macro references the named table on the original sheet.

Any simple references on how to learn the basics of working with dynamic references in writing/editing macros?

 

[RoryA]

If it will be the only table on the sheet, you can simply refer to it by the index number 1:

activesheet.listobjects(1)

 

[damckinley80]

If it will be the only table on the sheet, you can simply refer to it by the index number 1:

activesheet.listobjects(1)

Wow. I feel like a fool. Thanks!