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?
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
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.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
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)
