convert a worksheet with formulas to a macro
 

I have a worksheet with some cells(3 colluns) that are data input an
other cells that are formulas (10 colluns).
I want create a macro that will execute all formulas.
The general idea is:

some one send me a spread sheet with all datas, let say, the 2 collun
with 10 lines filled up with data
I open it and just click the macro button and I'll have the 2 origina
colluns and other new 10 colluns with the information created by th
formulas.

Some of the formulas colluns are intermediate steps to a final result
Let's say that I do a MID, but I need get the LENght of the word in
separate cell and then I use this cell on the MID cell.

Thanks
Marcel

--
Message posted from http://www.ExcelForum.com