VBA Suddnly Takes alot of time to Run

[AbdulkareemAlhassni]

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 ?

 

[Mentor82]

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]

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]

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]

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.