Hi!
I used the code below in a hidden worksheet so that if text is entered into a template and then deleted, the formulas will reappear. Sometimes, but not always, I receive the following error.
Run-time error '-2147417848 (80010108)' Method 'Formula' of object 'Range failed
This is the code that I am currently using.
The error is occuring at this point Target.Formula = Sheets("Saturday Hidden").Cells(Target.Row, Target.Column).FormulaPlease Login or Register to view this content.
Can someone please advise on what needs to be modified in order for the macro to work properly?
Bookmarks