I want to use the same VBA on multiple worksheets. Each worksheet has a table so I need to get the table name and then use that name for each worksheet
I have this to get the table name
Range("A12").Select
TableName = ActiveCell.ListObject.Name
I tried doing this but got an error
Range("TableName[[#Headers],[Area]]").Offset(1, 0).PasteSpecial Paste:=xlPasteValues
Any help would be appreciated
Thanks,
Greg
I have this to get the table name
Range("A12").Select
TableName = ActiveCell.ListObject.Name
I tried doing this but got an error
Range("TableName[[#Headers],[Area]]").Offset(1, 0).PasteSpecial Paste:=xlPasteValues
Any help would be appreciated
Thanks,
Greg