Run time error: 1004 Paste special method of range class failed

**amethystfeb** · 03-22-2014, 01:52 PM

Hi

I get this error when i copy columns from one workbook to another

Please Login or Register  to view this content.

I get this error when i paste in D2... Any suggestions please

**buran** · 03-22-2014, 02:21 PM

hi, note that you are using

Please Login or Register  to view this content.

construct, but in fact you don't have dot in front of respective range. so whatever you do, you do it in the active workbook.

**amethystfeb** · 03-23-2014, 12:02 AM

Hi,

Wen i put a .(dot) I get compliation error

Please Login or Register  to view this content.

**TMS** · 03-23-2014, 12:18 AM

Please Login or Register  to view this content.

Regards, TMS

**buran** · 03-23-2014, 02:04 AM

Thanks, TMS.

@ amethystfeb: Look at TMS code. It can be written also:

Please Login or Register  to view this content.

Re: Run time error: 1004 Paste special method of range class failed