I have the following code to name a range and then copy and paste to the variable name. All is ok up until the paste.
Can someone please tell me how I'm going wrong.
Thanks,
Ken Mc
Please Login or Register to view this content.
I have the following code to name a range and then copy and paste to the variable name. All is ok up until the paste.
Can someone please tell me how I'm going wrong.
Thanks,
Ken Mc
Please Login or Register to view this content.
Is the selected range a valid range?
Your copying over 2 million cells!
deactivate the On Error to trouble shoot.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Thanks, removed On Error. Range is a valid named range in my main workbook.
Still not working.
Well change the following line
orPlease Login or Register to view this content.
Go though it step by step and troubleshootPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks