Copy sheet text with no formulas

  • Morning All,


    So im copying a sheet full of formulas and i want to save the text rather that the formulas mainly due to the fact one of the formulas will delete all the text with a button click.

    This is the code im using to create a new sheet just need to know what coding would be the best to add to do this.


    Thanks in advance


  • Rather than trying to decipher your code, could you explain in words what you are trying to do with each line of code in your macro? It would also be easier to help if you could attach a copy of your file (de-sensitized of necessary).

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.