|re: "I want to copy paste value the figure from F20 to F21 rather than F21 being equal to F20"|
Huh? If you paste the value from F20 into F21 then F21 will be equal to F20. I mean, what else could it be equal to other than the value that was pasted into it?
What do you mean that you can't see the VBA code? Is the code protected from viewing?
If that's the case, then I guess that you will need a formula in F21. You either have to add code to the existing macro to populate F21 or call another macro from the timer code which will populate F21. In either case, you need to be able to edit the existing code. If you can't do that, you will have to use a formula within the spreadsheet.
What do you want in F21 when D4 is not equal to 100?
We'd need that information before we can offer any suggested formulas.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.