Help with table reference

[Ellen 2Excel]

I have the following code as part of a macro.
...Begin code
Range("Table13[[#Headers],[County]]").Select
Selection.Copy
Range("Table13[[#Headers],[Order ]:[TD Recording '#]]").Select
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
End Sub
...End code

Obviously the macro runs correctly if I am on the sheet where the table name = Table13. If I run the macro on another sheet, it won't complete because the Table name is different. How do I change the above so it will run regardless of what sheet I am on and not be table specific? The workbook can contain many worksheets, however, the column names are identical from sheet to sheet. Hope this makes sense...

[TMS]

See if this will get you going ...

Please Login or Register  to view this content.

Regards, TMS