Re: $$Excel-Macros$$ VBA to Destination of Value only

2012-12-30 Thread ashish koul
try this Sheets("DailyList").Range("ItemsList").Copy Destination:=Sheets("ItemsListArchives").Range("D" & Sheets("ItemsListArchives").range("a1048576").end(xlup).row) On Sun, Dec 30, 2012 at 1:15 PM, Cab Boose wrote: > Sheets("DailyList").Range("ItemsList").Copy > Destination:=Sheets("ItemsLis

$$Excel-Macros$$ VBA to Destination of Value only

2012-12-29 Thread Cab Boose
Hi I want to copy the values only to another sheet. Without .value on the end it copies thru with error messages. If I put . value on the end it comes up with message 'copy method of range class failed'. Do not want to use copy/paste special method. Want to use 'Destination" as shown. Shee