Cause and solution of slow execution of VBA!

Hey All!!
I have a VBA program and have couple of macros assigned to a button.. I was wondering why my Macro is slow even if it is not so lenthy..
But while debugging i have found that code goes to "worksheet_change" frequently and the debugging takes very long time so the macro is taking time...
But i have a question that while my macro is running, in middle of debugging, why is it going in Worksheet_change even if it doesnot have any link...
EXAMPLE:

Please Login or Register  to view this content.

in the above code, after last line " Range("F2").Value = "2015 ABC corp ltd "
it goes to another WORKSHEET_CHANGE while debugging...

Please Login or Register  to view this content.

not Just this, but it goes frequently in worksheet change which i think is useless......
I dont want this... because of this my macro is taking like 3-4 secs to execute..
Any help would be appreciate...
Please Reply

Out of context it's hard to suggest based on a couple of lines of code, but you could try turning off Event handling. Not forgetting to turn it on again at the end

Please Login or Register  to view this content.

Yea Great! thanks for your reply.. Now it is not going to the Worksheet_Change but still the code is running very slow.. like it takes 3-4 seconds..
Below is the code.. Please help me what can i do with the following code to make it faster..

Please Login or Register  to view this content.

Another thing that the code is linked up with 3-4 pivot tables....

After seeing the fulll code, that change wouldn't have made a big difference...

And you're working with the slowest thing of all in Excel, pretty user interface elements. I can't really suggest anything because the code is very specific to your workbook so any changes are going to have to be made, and tested, separately.

I would, however, go back and look at the code closely and see if everything is absolutely essential. For example

Please Login or Register  to view this content.

You can also rationalise the code a little. Instead of

Please Login or Register  to view this content.

You could use

Please Login or Register  to view this content.

While that's not going to shave seconds off the total time, optimise as much as possible and you might see some worthwhile gain.

Thanks.. hope to get more help from experts...

I have shown my code in the above post...
No,.. Worksheet_activate will not be possible because it is not the event that i want... The event has been stopped already.. read my above posts.......
Just want my macro to run fast...
thanks

Anyone has idea?? want to help me please??

???????????????????

<BR>

???????? No one can help me?????????

I'm no 'expert' - but I will say you are not going to have much luck getting that to run appreciably faster.

Thelongpants made a valid point above as to why you run this when it does not seem like it is necessary to run it and you seem to have discounted/ignored my suggestions.

That's your perogative, of course, but you will not make many friends by peppering the board with silly posts like the last 4 or 5.

Hi meus,

It is difficult to debug your problem without a sample file. In general, you will get a quicker, more accurate response if you upload a sample file in addition to posting your macro that gives you problems.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Lewis

Sorry if i was rude or behaved negative on board...
I found that the source file was too heavy which leading to slow macro...
Because that macro uses 4-5 pivot tables to filter and use slicer, it was becoming slow... I had somewhere around 40000 rows data and i deleted it to 5000 data, it was running fast.. It might be because of heavy source file + the pivots i am using...

Thanks..

thanks...........