Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Function gets slower every time I use it...
Hi all
I have a function which splits text for me. I autofit the width of the column and compare it to the width that i have declared. if the column width is wider than mine, i go to the next line. this functions works slow, but I've noted, that every time the function runs again, it is getting slower. first time it runs about 30seconds, 2nd time it runs 45seconds, 3rd time more then a minute!! I don't know why this happens, could that have something to do with memory which isn't released exactly? Thanks for any help Carlo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macros making files slower and slower | Excel Discussion (Misc queries) | |||
String manipulation in macro runs slower each time ran. | Excel Programming | |||
Excel gets slower and slower.... | Excel Programming | |||
Slower run with many sheets | Excel Programming |