Results 1 to 5 of 5

Thread: VBA Suddnly Takes alot of time to Run
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Nov 2018
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default VBA Suddnly Takes alot of time to Run

    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 ?

  2. #2
    Board Regular
    Join Date
    Dec 2018
    Location
    Poland
    Posts
    203
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    1 Thread(s)

    Default Re: VBA Suddnly Takes alot of time to Run

    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.

  3. #3
    New Member
    Join Date
    Nov 2018
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: VBA Suddnly Takes alot of time to Run

    Quote Originally Posted by Mentor82 View Post
    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-...ml#post5326631

    Here you will find my report code

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

  4. #4
    Board Regular
    Join Date
    Dec 2018
    Location
    Poland
    Posts
    203
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    1 Thread(s)

    Default Re: VBA Suddnly Takes alot of time to Run

    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

  5. #5
    New Member
    Join Date
    Nov 2018
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: VBA Suddnly Takes alot of time to Run

    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.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •