Hi,
Could you please explain why this line returns an error?
Screenshot 2021-06-08 150221.jpg
The line above is exactly the same and is working fine. Additionally, the same code works with no troubles in another workbook.
Thanks for your help.
Hi,
Could you please explain why this line returns an error?
Screenshot 2021-06-08 150221.jpg
The line above is exactly the same and is working fine. Additionally, the same code works with no troubles in another workbook.
Thanks for your help.
Last edited by kapi98; 06-08-2021 at 07:10 PM.
What is the ActiveSheet when this code executes?
What module contains this code?
At the point where the error occurs, I would go to the immediate window and type
?Range("A178").Parent.Name
?ActiveSheet.Name
and see if they are the same sheet. My guess is that they are different and the see you are changing is still protected.
We could run this down a lot faster if you attach your file so we can run the code. See yellow banner at the top of the page.
Oh, by the way, why are you assigning "239" instead of 239? That has nothing to do with your error, just seems unusual.
Thanks for your help. I've slightly rewritten the code ad it's now working well.
Could you please share the rewrite? It may help someone else with a similar problem who finds this thread in a search. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks