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 swch...@gmail.com wrote: Sheets(DailyList).Range(ItemsList).Copy

$$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.