Recalculation taking a massive 11 seconds
 

Hi,

I've designed a simple spreadsheet that's looking at a small table of
data and returning 2 values.

(The sheet gets updated by external means, hence I'm using the
worksheet_calculate event).

The average of the 2 is then calculated and used to display historical
Min and Max values (in the Yellow boxes).

These 3 (Average, Min Average, Max Average) are then rounded to
predefined increments.

When I choose selection "A" or "D" and run my code (from a cmdButton)
it takes a MASSIVE 11 seconds on my well specced PC..

But if I choose "B", "C", or "E" and run my code it takes less than 1
second.

My VLOOKUPS seem to be fine, the problem lies somewhere in my MROUND /
INDEX / MATCH formula...


It's maybe best that you look at the attached example 'dave.xls' and
ask if there's anything that you don't understand because I'm useless
at explaining things!

Can someone please help me clean up my code, or work out what is
wrong?

Thanks,

Dave


+-------------------------------------------------------------------+
|Filename: dave.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4034 |
+-------------------------------------------------------------------+

--
David.Allen297
------------------------------------------------------------------------
David.Allen297's Profile: http://www.excelforum.com/member.php...o&userid=27820
View this thread: http://www.excelforum.com/showthread...hreadid=484471

Recalculation taking a massive 11 seconds
 

Your attachment did not show. You may send to my private email a SMALL
workbook with a DETAILED explanation so I don't have to come back here. I
will then take a look.

--
Don Guillett
SalesAid Software

"David.Allen297"
<David.Allen297.1yd0ra_1131758401.8789@excelforu m-nospam.com wrote in
message news:David.Allen297.1yd0ra_1131758401.8789@excelfo rum-nospam.com...

Hi,

I've designed a simple spreadsheet that's looking at a small table of
data and returning 2 values.

(The sheet gets updated by external means, hence I'm using the
worksheet_calculate event).

The average of the 2 is then calculated and used to display historical
Min and Max values (in the Yellow boxes).

These 3 (Average, Min Average, Max Average) are then rounded to
predefined increments.

When I choose selection "A" or "D" and run my code (from a cmdButton)
it takes a MASSIVE 11 seconds on my well specced PC..

But if I choose "B", "C", or "E" and run my code it takes less than 1
second.

My VLOOKUPS seem to be fine, the problem lies somewhere in my MROUND /
INDEX / MATCH formula...


It's maybe best that you look at the attached example 'dave.xls' and
ask if there's anything that you don't understand because I'm useless
at explaining things!

Can someone please help me clean up my code, or work out what is
wrong?

Thanks,

Dave


+-------------------------------------------------------------------+
|Filename: dave.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4034 |
+-------------------------------------------------------------------+

--
David.Allen297
------------------------------------------------------------------------
David.Allen297's Profile:
http://www.excelforum.com/member.php...o&userid=27820
View this thread: http://www.excelforum.com/showthread...hreadid=484471