LinkBack URL
About LinkBacks
Tried to copy a worksheet and assign a variable to this copy at the same time as follows,
but I got error message as follow,
Please Login or Register to view this content.
Run-time error '424':
Object Required
Any help on this...
VBA Code Problem (Excel 2010):Runtime error 424
Tried to copy a worksheet and assign a variable to this copy at the same time as follows,
but I got error message as follow,Please Login or Register to view this content.
Run-time error '424':
Object Required
Any help on this...
Last edited by arlu1201; 11-27-2012 at 01:06 AM. Reason: Use code tags in future.
A. you should have your Code in CodeMarks...
you have not designated any object i think... though i am not sure if it is neccessaryy...
If you try...
Let me know, just a guess, havnt tested itPlease Login or Register to view this content.
When you copy a worksheet an object isn't returned.
What you can do is because the new sheet becomes the active sheet is create a reference to the active sheet immediately after the copy.
Please Login or Register to view this content.
Last edited by Norie; 11-26-2012 at 04:44 PM.
If posting code please use code tags, see here.
OK, i understand... i think... as i said, it was just a guess...
i am learning still as well...
So the whole code would be...
???Please Login or Register to view this content.
Is that right?
Last edited by Legend Rubber; 11-26-2012 at 04:17 PM. Reason: Add y to "cop"y
I think I answered my own question. I have done some tests and I found out that I was trying to treat a Boolean expression as an object.
Aelgadi,
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks