Yes Goto did work, but it updates the screen to the selection even though I have screen Updating off. Is there a way to do this without selecting the table?
My Variables are declared and initialized in a Public Variables module that is fired at the beginning of this code.
One additional item I want the code to sort the table after inserting the new data, but the following throws an "Object doesn't support property or method."
With wsTL.ListObjects("Turnslist")
.SortFields.Clear
.SortFields.Add _
Key:=Range("Turnslist[[#All],[Column1]]"), SortOn:=xlSortOnValues, Order _
:=xlAscending, DataOption:=xlSortNormal
.Apply
End With
Bookmarks