VBA for converting formulas to text

Good day everyone, I have a following Worksheet_Activate module under sheet 1, which performs a few actions. But one of he key things it does is convert formulas to text. However it does not seem to work. Would anyone be able to have a look and tell me if potential sources of error exist in the code?

Please Login or Register  to view this content.

Hi,

Could you please attach your workbook with the code and an explanation of what to do, the results that you are getting, and the results that you are expecting?

Thanks