VBA code only works when i entered values manually

[keshavtale]

In the attached file there is VBA code , use of this code is find specific sum of values and highlight that values, you can see in that file cell A2, A3, A4 is highlighted
because sum of that values is 433159 get matched which i entered in VBA code, but problem is now i use msoffice 2016 i do not know that is the reason behind it or any other reason , now this code only works when i entered values manually in A column, and whein i copy paset values then code not work
please give me solution of that problem