Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working of formula in Macro.
Hi,
I have written a macro which process around 50000 rows in a spreadsheet and i have used VLOOKUP function in it. When i use this function normally(I mean manually) it takes around 2 mins to pop-up the values in spread sheet and macro process it in seconds. I just wanted to know does that macro waits untill the data is populated or not. Regards Heera Chavan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working of formula in Macro.
hi,
Updating your worksheet 'on the fly' while running a macro causes everything to slow down so it's often beneficial to stop it and also stop calculation and re-start at the end like this sub nn() Application.Calculation = xlCalculationManual Application.ScreenUpdating = False 'Your code Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Heera" wrote: Hi, I have written a macro which process around 50000 rows in a spreadsheet and i have used VLOOKUP function in it. When i use this function normally(I mean manually) it takes around 2 mins to pop-up the values in spread sheet and macro process it in seconds. I just wanted to know does that macro waits untill the data is populated or not. Regards Heera Chavan . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA formula in macro not working | Excel Discussion (Misc queries) | |||
Formula within a Macro not working as expected. | New Users to Excel | |||
Macro formula using MYDATE not working | Excel Programming | |||
macro was working, now it's not working | Excel Programming | |||
Macro working in Excel 2003; not working in Excel 2000 | Excel Programming |