Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Size Matters - minimizing file size
I have a worbook containing several macros and lots of formulas that
has grown to big. The only way to trim the file size down is to delete rows containing formulas that are as of yet unused but will be as more data is entered. These cells will eventually be required to carry out calculations on cells populated by the user. I.e columns A-C are text id's, D:AG is data entered by the user and AH:CT is formulas that manipulate the data with a corresponding outcome in column CU that is acted on by a macro. Is the best thing to have a workbook macro that copies the formula in columns AH:CT when the user inputs text in column B? Does anyone know a simple way to implement this? Any help gratefully appreciated Regards Jamie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Staus Bar - Size Matters | Excel Discussion (Misc queries) | |||
File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
size matters : ) | Excel Discussion (Misc queries) | |||
Tips for Minimizing size of Pivot Table workbooks | Excel Discussion (Misc queries) | |||
How to get the size of the excel file, a sheet size (in bytes)? | Excel Programming |