Delete not selected columns

  • Hi there,

    I have a table and, using union command, I select some columns.

    My issue is that I need to delete the columns on table which are not selected.

    Due to there're some formulas on table, I need this because I need to keep the formulas valid, just recalculate with selected columns.

    it's also OK for my purpose, just clear the content if it's easier.

    any suggestion?

  • I can't promise a solution but it would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

    You can say "THANK YOU" for help received by clicking the "Like" 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.

  • Thanks for your reply.

    In the meantime I completely change my code because I understood that this way was too complicated.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!