| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calc mode question
i have this code that loops as it build a formula
Application.Calculation = xlCalculationManual for i = 1 to 10 Range("B4").Formula = Range("B4").Formula & "+'" & fPath & FileName$(i) & "Trans'!$F4" Range("C4").Formula = Range("C4").Formula & "+'" & fPath & FileName$(i) & "Hours'!$F4" next i if i turn on screen updating, i can see each cell being calculated as it builds the formula. any way to turn of calculations so the cells aren't updated as they're built? -- Gary |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
calc mode question
build the formulae as strings and then put them into the cells using
..formula Charles ______________________ Decision Models FastExcel 2.1 now available www.DecisionModels.com "Gary Keramidas" wrote in message ... i have this code that loops as it build a formula Application.Calculation = xlCalculationManual for i = 1 to 10 Range("B4").Formula = Range("B4").Formula & "+'" & fPath & FileName$(i) & "Trans'!$F4" Range("C4").Formula = Range("C4").Formula & "+'" & fPath & FileName$(i) & "Hours'!$F4" next i if i turn on screen updating, i can see each cell being calculated as it builds the formula. any way to turn of calculations so the cells aren't updated as they're built? -- Gary |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
calc mode question
Application.ScreenUpdating = False
<vba code Application.ScreenUpdating = True 'Don't forget to put it on!!! -- Ronald Ferdinandus http://www.ro-pay.nl "Gary Keramidas" wrote: i have this code that loops as it build a formula Application.Calculation = xlCalculationManual for i = 1 to 10 Range("B4").Formula = Range("B4").Formula & "+'" & fPath & FileName$(i) & "Trans'!$F4" Range("C4").Formula = Range("C4").Formula & "+'" & fPath & FileName$(i) & "Hours'!$F4" next i if i turn on screen updating, i can see each cell being calculated as it builds the formula. any way to turn of calculations so the cells aren't updated as they're built? -- Gary |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
calc mode question
thanks, doing that cuts it from 30 some seconds to about 6 seconds. i
haven't tried it on the clients slow machine yet, but it took over 3 minutes the original way. thanks again -- Gary "Charles Williams" wrote in message ... build the formulae as strings and then put them into the cells using .formula Charles ______________________ Decision Models FastExcel 2.1 now available www.DecisionModels.com "Gary Keramidas" wrote in message ... i have this code that loops as it build a formula Application.Calculation = xlCalculationManual for i = 1 to 10 Range("B4").Formula = Range("B4").Formula & "+'" & fPath & FileName$(i) & "Trans'!$F4" Range("C4").Formula = Range("C4").Formula & "+'" & fPath & FileName$(i) & "Hours'!$F4" next i if i turn on screen updating, i can see each cell being calculated as it builds the formula. any way to turn of calculations so the cells aren't updated as they're built? -- Gary |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
calc mode question
just ran it on my client's pc, took 30 seconds instead of 3 and a half
minutes. thanks again -- Gary "Charles Williams" wrote in message ... build the formulae as strings and then put them into the cells using .formula Charles ______________________ Decision Models FastExcel 2.1 now available www.DecisionModels.com "Gary Keramidas" wrote in message ... i have this code that loops as it build a formula Application.Calculation = xlCalculationManual for i = 1 to 10 Range("B4").Formula = Range("B4").Formula & "+'" & fPath & FileName$(i) & "Trans'!$F4" Range("C4").Formula = Range("C4").Formula & "+'" & fPath & FileName$(i) & "Hours'!$F4" next i if i turn on screen updating, i can see each cell being calculated as it builds the formula. any way to turn of calculations so the cells aren't updated as they're built? -- Gary |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
calc mode question
had that, just turned it off to see the calcs
-- Gary "RonaldF" wrote in message ... Application.ScreenUpdating = False <vba code Application.ScreenUpdating = True 'Don't forget to put it on!!! -- Ronald Ferdinandus http://www.ro-pay.nl "Gary Keramidas" wrote: i have this code that loops as it build a formula Application.Calculation = xlCalculationManual for i = 1 to 10 Range("B4").Formula = Range("B4").Formula & "+'" & fPath & FileName$(i) & "Trans'!$F4" Range("C4").Formula = Range("C4").Formula & "+'" & fPath & FileName$(i) & "Hours'!$F4" next i if i turn on screen updating, i can see each cell being calculated as it builds the formula. any way to turn of calculations so the cells aren't updated as they're built? -- Gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MODE calc where more than one mode number! | New Users to Excel | |||
| SUMPRODUCT calc question | Excel Worksheet Functions | |||
| Open CSV causes calculation in manual calc mode | Excel Discussion (Misc queries) | |||
| Calc mode display on worksheet | Excel Worksheet Functions | |||
| Re-calc. speed question | Excel Worksheet Functions | |||
![Gary Keramidas[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
