Excel VB Convert Bulk Cell Formula To VB Code

  • Hi,


    Need some help here, i have a spreadsheet contained many formulas in different cells, i know i can use macro recorder to convert them to vb code, but there are too many of them, eg. more than 50 formulas, so i need to manually select the cell formula, copy and paste in each cells, repeat the process and all will capture in recorder, but doing it for more than 50 formula is not a good idea.


    So is there a way to copy and paste the formula and convert all of them in bulk to vb code?


    i have been searching over the internet but have not seen anything about bulk conversion to vb code.


    would appreciate your help and advice.


    thank you.

  • Re: Excel VB Convert Bulk Cell Formula To VB Code


    Hi,
    My thought is it would be much faster to process the data when using vba and also to prevent someone accidentally deleted cell formulas as the worksheet contained lot of formula.


    Thank you.

  • Re: Excel VB Convert Bulk Cell Formula To VB Code


    I'm not sure it will be faster, and you could always protect the cells with formulae.


    If you did this, what exactly do you envisage the code doing? Presumably you want it to find each formula in the sheet. And then do you want them stored in another sheet and applied via VBA, or just converted to a value? If it's a one off exercise obviously you don't need to store them.