Macro Execution

  • Thread starter Thread starter Tony P.
  • Start date Start date
T

Tony P.

I have a spreadsheet which contains a macro that deletes duplicate rows.
There are over 9000 rows of data in this spreadsheet. Whenever I run the
macro, I get an hourglass icon which persists for quite awhile waiting for
the macro to execute through all of the rows. During this time, I'm not
sure if the macro is actually running or that the program has locked up &
froze. Is there a way to add some sort of progress indicator to the screen
which would output a message every so often saying that the program is
still running?

Thanks,
Tony
 
Tony,

You could use the status bar in your loop to display which row is
being deleted.

If rngR is the range of the duplicate being deleted,

Application.StatusBar = "Deleting Row " & rngR.Row & " .............."

To reset the status bar, after the loop.

Application.Statusbar = False

HTH
Paul
 
Back
Top