When you use the status bar to display a message to the user, that message will be displayed until your code returns control of the status bar back to Excel. This may be a problem when you use it to display a "Macro Complete" message -- the message will always remain in the status bar.
The Status Bar property of the Application object in Excel VBA can be used to indicate the progress of a lengthy macro.
Even inexperienced VBA coders, that write their own code, often and up with the same problem due to their code being full of Select, Selection, Activate etc.
Not only is it off-putting for the end user but it also causes macros to run much slower.
This is understandable since the workbook has thousands of formulae, and I wont ba able to avoid it (I think) Is there no way to read "excel calculated percentage" from somewhere? Okay I know this is quite big but is it that unusaul?
The workbook acts as a complete budgeting program so I was expecting it to be a bit bigger than usaul but does 45MB sound completely bizzare?
Screen Updating = False For Each r Cell In Range("A1: A15000") r Cell. Instant Download and Money Back Guarantee on Most Software Excel Trader Package Technical Analysis in Excel With 9.00 of FREE software! Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To......
There was I assuming that when MS told me it was saving it was. Shame about that array 65536 limit though (not this thread) I have modified solver now (silly me) and all appears ok.
The status bar portion of the Excel screen gives you a simple and convenient method do display message to the user.
This way, you can let the user know that a macro is still running.
Situation: The macro we are going to create fills Range("A1: E20") with random numbers.