VBA Suddnly Takes alot of time to Run

AbdulkareemAlhassni

New Member
Joined
Nov 16, 2018
Messages
41
Dear all,

i noticed suddenly that my VBA is taking so much time to run the VBA, i dont know why

for example to filter and unfilter an entire row it starts from Threadh (0%) and takes 5 minutes to reach Threads ( 100% )

that's only to filter and unfilter one row !!!!


can someone please help :( ?
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Mentor82

Active Member
Joined
Dec 30, 2018
Messages
307
Hi,
While filtering in excel it calculayes all the cells that have formulas. If you have a great #of records with formulas it may take time. Do you have plany of formulas especially nested ones in the worksheet? How many records do you have? It would be great if you share your file on dropbox maybe in order to have look what you've got there.
 

AbdulkareemAlhassni

New Member
Joined
Nov 16, 2018
Messages
41
Hi,
While filtering in excel it calculayes all the cells that have formulas. If you have a great #of records with formulas it may take time. Do you have plany of formulas especially nested ones in the worksheet? How many records do you have? It would be great if you share your file on dropbox maybe in order to have look what you've got there.

https://www.mrexcel.com/forum/excel...effort-code-can-you-check-up.html#post5326631

Here you will find my report code

kindly check it up and give me a feedback in that post
 

Mentor82

Active Member
Joined
Dec 30, 2018
Messages
307
Hi,
Thanks for sending a link to your code but why did you open another thread about the same topic bit different named a little bit? Why don't you patiently wait for reply in this thread and place another one for the same issue breaking the forum rule #12 ?
In my opinion, this topic is closet and I recomend you wait for reply within another thread you placed.
Regards,
Sebastian
 

AbdulkareemAlhassni

New Member
Joined
Nov 16, 2018
Messages
41
No its not the same issue,

i fixed the lagging issues of the report because i was copying data till end of sheet.

i used last row.count

and i fixed everything.

so i dont have VBA taking long time.

that's why i opened a new topic where i want people to give me advice overall regarding my code.

so its not the same topic.

:)

anyhow thanks for your help.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,948
Messages
5,525,809
Members
409,664
Latest member
Sonymacd

This Week's Hot Topics

Top