I have two tables, tblEnlisted (5 columns) and tblDay1 (1st row only - no data). I tried variations of code to copy columns 3, 4, 5 from tblEnlisted to column 1, 2, 3 of tblDay1. The last code I tried;
Sheet2.Range("tblEnlisted[[Name],[Sex],[Index]]").Copy Destination:=Sheet7.Range("tblDay1[Column1]")
gives an error - Method 'Range' of worksheet'_Worksheet' failed
Where did I go wrong?
If source columns are consecutive, try:
Sheet2.Range("tblEnlisted[[Name]:[Index]]").Copy Destination:=Sheet7.Range("tblDay1[Column1]")
Thank you for your reply. Still get same result.
Then you should upload a sample file so we can see what's wrong, works on my side.
Hi Catalin,
I have resolved the issue with the following.
Sheet2.Range("tblEnlisted[[Name]:[Index]]").Select
Selection.Copy
Sheet7.Select
Sheet7.Range(rng).Select
ActiveSheet.Paste
Thank you for your time and concern.
Sal
