Copy Data from a Table

[gheyman]

I have a table (dmVendors) on sheet11 where I want to copy all the data except the field/row names to another sheet sheet9.Range(A2)

I want to paste the data starting in Row 2 on the second sheet which is not a table. My table will vary in the number of Rows and columns

Any help is truly appreciated.

 

[Fluff]

How about

Sub gheyman()
   Sheet11.ListObjects("dmVendors").DataBodyRange.Copy Sheet9.Range("A2")
End Sub