LinkBack URL
About LinkBacks
I have the following code below in a specific Sheet (A1) and if I copy and paste values in this sheet I get a Runtime error - Type Mismatch.
Can anyone help?
Please Login or Register to view this content.
I have the following code below in a specific Sheet (A1) and if I copy and paste values in this sheet I get a Runtime error - Type Mismatch.
Can anyone help?
Please Login or Register to view this content.
When you DEBUG, exactly which line of code is highlighted?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Please Login or Register to view this content.
When you get the error have you copy/pasted multiple cells/rows/columns?
If posting code please use code tags, see here.
If you've pasted more than one cell, that code would be problematic. You need to add the ability for the code to "loop" through all the multiple pasted cells that intersect your watch range, like so:
Please Login or Register to view this content.
It is giving me an error still based on the entire code above. Can you show me how to change the entire code listed above.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks