Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
Macro changes formulas on destination worksheet | Excel Discussion (Misc queries) | |||
Macro to convert Name of worksheet | Setting up and Configuration of Excel | |||
Macro to combine several worksheet formulas | Excel Programming | |||
Macro to add formulas to added worksheet | Excel Programming |