I love VBA and tend to use it everywhere, even when a formula will do the job for me.However, I also see a lot of bad habits from people which makes me less warm and fuzzy and more .. I am a programmer in the real world and thought I'd list down some good habits when programming in VBA. I would always recommend people use Option Explicit in all of their programs. Here is a pic of the status bar while the macro is running.
If you are not changing the value, only reading it, then you will want to pass By Val (By Value). If I had a penny for every time I saw someone use . I generally only use the Macro Recorder when I want to see how to programmatically write out something quite complex (it will do it all for me). The amount of lines of code I look at on a daily basis are in the thousands, and it takes me at least 4 times as long to understand WTF you have done because there are no comments.Here is a simple code which gives a message box showing the values in column A starting from row 2 to the last row. The status bar will show the message “Macro running” as the code is running, and once the code is done, it will show “Ready” which is one of the default Excel messages. Display Status Bar = True With Worksheets(“Sheet1”) lrow = . “Used Cell” is defined as Cell containing formula, formatting, The above procedure work under normal circumstances, but it does not work in some cases where the data source was downloaded from other system. In that case you should use the below procedure to clear all empty cells and then delete the row. Screen Updating = False For Each usedrng In Active Sheet.