Prev: Preventing "Protect Workbook"
Next: RECORDSET file name length limit?
From: Heera on 9 Feb 2010 04:55
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
From: Mike H on 9 Feb 2010 05:48
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
> .
>
 | 
Pages: 1
Prev: Preventing "Protect Workbook"
Next: RECORDSET file name length limit?