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.