Using TextReplace to change a formula and then calculate with it
I am working on a project that requires the user to enter a number, this number is then used to replace "X"s in formula pulled from a table using other info gleened from the users inputs for the table, row and column attributes.
I have successfully got this far using the TextReplace function and replacing any "X"s in the formulas in the table with the numbers entered by the user, and can then "Display" the new formula complete with the users number where the "X"s were.
Now I have that part tested and working I am struggling to find a way to actually calculate and display the result of that formula now it has the "X"s replaced by the users number, rather than displaying just the formula itself!
I know I'll probably kick myself for missing something obvious, but I really am stumped after many hours of trying all sorts to get this "simple" next and final step working, and once I figure this bit out I am virtually ready to publish, so I decided it's time to admit defeat and seek advice from the pro's!
So can anyone help before I go mad, bald or just give up!??