We attempt to paste the copied range into theB3:B5range ofSheet1inWorkbook2. However, when we run this code, it displays aPasteSpecial Method of Range Class Failederror. This occurs because the moment we create the new workbook (Workbook2), thecopy/paste modeis canceled. Solution To resolve...
I am using Excel 2003 SP2 on a Windows 2000 machine I am receiving Runtime Error '1004': PasteSpecial Method of Range Class Failed when running a macro...