Log In
Register
Home
Excel Tables
May 27, 2019
Offline
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?
November 8, 2013
Offline
If source columns are consecutive, try:
Sheet2.Range("tblEnlisted[[Name]:[Index]]").Copy Destination:=Sheet7.Range("tblDay1[Column1]")
Excel Tables
May 27, 2019
Offline
Thank you for your reply. Still get same result.
November 8, 2013
Offline
Then you should upload a sample file so we can see what's wrong, works on my side.
Excel Tables
May 27, 2019
Offline
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
1 Guest(s)
