Hello,
I keep getting an error message appearing when I use the ActiveSheet.Paste code.
"Paste method of worksheet class failed"
Does anyone know why?
Cheers,
Boxcaru
Hello,
I keep getting an error message appearing when I use the ActiveSheet.Paste code.
"Paste method of worksheet class failed"
Does anyone know why?
Cheers,
Boxcaru
Please post the code (remembering to use VBA tags!), and indicate the line where it fails.
Patrick
it's ok.
I sorted it.
Thanks though
Hi Boxcaru,
If this is solved, Can you mark it so using Thread Tools at the head of the page
Regards
MD
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'