Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting cell formulas to into VB
i have many complex spreadsheets that contain thousands of rows of data. i
have created one that extracts all the data i need from all the right places and puts it into a neater more precise format so i can work with it easily. however because i have done this using only formulas on the spreadsheet (thousands of of complicated ones running the length and breadth of the page) my computer slows right down and whenever i alter anything in the workbook it takes a very long time to respond. is it possible to instaed of having all these formulas in the cells, program the cells with macros and VB so you dont actually see the formula in the cell, the result just appears without using all the memory? or is there any better suggestions? help would be much obliged tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting formulas to code | New Users to Excel | |||
Converting formulas to value | New Users to Excel | |||
Cells converting ###s to formulas | Excel Discussion (Misc queries) | |||
Converting to and from Named Formulas | Excel Programming | |||
Converting text to formulas | Excel Worksheet Functions |