I have a macro that will be used on multiple sheets. Each sheet will have a Table (table will be the same size and have the same headers on each sheet). I want to run a macro that can be used on each sheet, my issue is that the tables will all have different names and I want to reference the table name for the current sheet. This is what I have tried (and failed) to come up with.
Sub Different_Tables()
Range("A1").Select
Dim ws As Worksheet
Dim tName As String
Set ws = ActiveSheet
tName = ActiveCell.ListObject.Name
Range("tName[[#Headers],[CATEGORY]]").Offset(1, 0).Select
End Sub
Hope someone can help
Thanks,
Greg
Sub Different_Tables()
Range("A1").Select
Dim ws As Worksheet
Dim tName As String
Set ws = ActiveSheet
tName = ActiveCell.ListObject.Name
Range("tName[[#Headers],[CATEGORY]]").Offset(1, 0).Select
End Sub
Hope someone can help
Thanks,
Greg