why does worksheet need to be active to manipulate?

[ilya2004]

Hi all,

I had some code that would manipulate cell values on different sheets. I am not sure what happened but it recently stopped running the code to change a cell's value if that worksheet isn't active.
Instead I get an application-defined or object-defined error.

I would even write out the full address of the code, for example

Sub Demo()
Sheets("Input").Range("A1")= "Test"
Sheets("Formulas").Range("b12")= "Test2"
End Sub

Unless the sheet is active, I get an error. It used to work fine, so I am not sure what happened. Any ideas?

 

[ilya2004]

Ok, I will give it a try, thanks for your help.