| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculating Selected Cells
Hi, I need a little help here, I'm working in a "heavy" spreadsheet that has hundredrs of arrays, lots of macros and other staff. In my macros I used Activesheet.Calculate so it does'nt calculate the whole workbook everytime. Also I've pase all the possible values to make the file "lighter", but what I can't do is make it work faster, sometimes I've change just one formula and I have to calculate the whole sheet (SHIFT+F9) to get the result (I've disabled the automatic calculation) Is there any way to calculate just one cell or a group of them? Thanks NlCO -- NlCO ------------------------------------------------------------------------ NlCO's Profile: http://www.excelforum.com/member.php...o&userid=26123 View this thread: http://www.excelforum.com/showthread...hreadid=394528 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i put a negative sign on a range of selected cells? | Excel Discussion (Misc queries) | |||
| CALCULATING CELLS AS A TOTAL | Excel Discussion (Misc queries) | |||
| Calculating without including Hidden Cells | Excel Discussion (Misc queries) | |||
| how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) | |||
| Selected cells grow and data entry impossible EXT is dissabled | Excel Discussion (Misc queries) | |||
Threaded Mode
