Run time error 1004 assigning a value to a cell

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.

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.

Could you please share the rewrite? It may help someone else with a similar problem who finds this thread in a search. Thanks.