+ Reply to Thread
Results 1 to 1 of 1

How to force a macro to wait for a large sheet sort to finish

  1. #1
    Registered User
    Join Date
    02-04-2005
    Posts
    1

    How to force a macro to wait for a large sheet sort to finish

    This may be a simple problem but I have looked and cannot seem to find any answer to this. Basically, I have a large sheet. In my macro, I fill-handle a formula down Col I which holds either a "" or "-" (formula result). I then want to sort the data by this Col I (put all rows with a "-" in Col I at the bottom), and then copy those rows with the "-" and paste them in another sheet. The problem is that the sort is not finishing before the macro hits my copy code. How do I force the macro to wait for the sheet to finish sorting before moving on. For that matter, how am I sure the fill-handle is finishing (this could also be a quite large task) before the sort is happening. The only similar thing was a backgroundrefresh = false on querytables, but this is not a query table. Help?

    I should say as well that I would rather not break up the macro code into separate macros which run in sequence.
    Last edited by nicohlis; 02-04-2005 at 01:35 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1