Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time Lag
Hi All
I don't know if anyone will beable to help me, but my problem is as follows. I have a section of code that gets one column and fills it into the next column. Now that doesn't sound very hard does it? So I do that but unforunately every time that I execute this piece of code the computer hangs. At first I though it might be a calculation thing so I have turned calculation to manual to stop this problem but I can not think what else might be around to make the programme go this slow. There is only around 15 data values 2 of which are formulas being filled and nothing relies on the results of the fill. Hope I haven't confused anyone. But do you know of any other objects that I might beable to turn off to make this operation quicker?? Thanks heaps Jase |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time Lag
Jase,
Are you selecting the whole column, or just a data range? It may pay to post you code to the newsgroup, as it soulds like you may have some sort of looping error. HTH, Paul Mac. -----Original Message----- Hi All I don't know if anyone will beable to help me, but my problem is as follows. I have a section of code that gets one column and fills it into the next column. Now that doesn't sound very hard does it? So I do that but unforunately every time that I execute this piece of code the computer hangs. At first I though it might be a calculation thing so I have turned calculation to manual to stop this problem but I can not think what else might be around to make the programme go this slow. There is only around 15 data values 2 of which are formulas being filled and nothing relies on the results of the fill. Hope I haven't confused anyone. But do you know of any other objects that I might beable to turn off to make this operation quicker?? Thanks heaps Jase . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions |