Use Application.ScreenUpdating to speed up your code

Sometimes you write some code and it works well enough for what you're trying to do. And maybe you add some features here-and-there, making your VBA code more powerful. But after a while you notice that the code you wrote is taking a very long time. Does this sound familiar to you? Application.ScreenUpdating might be your answer. (adsbygoogle = window.adsbygoogle ...

How to Capitalize Names in Excel

Having nicely formatted data is a must if you plan on showing your spreadsheets to anyone who's willing to look at them. And while you may know how to color or change the font type, sometimes (well, maybe a lot of the time) your data itself might need some formatting from within. One of those times you may need to ...

Excel Shortcuts on Your Mac Keyboard!

Do you like to move quick in Excel? And I mean lightning fast. For example, have you ever typed a little, then move your hand to the mouse to click the toolbar area? Then move back to the keyboard, back to the mouse, the keyboard, the mouse....you get the idea. It reminds me of Filbert from Rocko's Modern Life when ...

Excel Dashboard Course

Do you want to┬áreally impress your manager? Or your manager’s manager? Then you should learn how to create Excel dashboards. Seriously, this is like catnip for managers. If you want to know how to create beautiful graphs that really convey the message of where the company is and where they need to go (which is extremely important to managers), then …

Using Enum to Keep Track of Worksheet Columns

If you code much in VBA, you have probably had to manipulate worksheets at some point. There are some common ways to work with worksheets through VBA. You have the Range object, where you can write in a string of the address you need to access. And you have the Cells object, where you use the [Row,Column] notation to access …

Alternative to Multiple IF Statements

Have you ever had to create a multiple IF statement? Ever notice how crazy it looks with all those parentheses and it's difficult to follow? Well, I was wondering if there was another way I could create a multiple IF statements that would be cleaner and easier to edit if need be. And I have. What I have discovered isn't ...

Arrange Windows for the Obsessive Compulsive

I’m sure you can find how to Arrange Windows in Excel all over the web; it’s been covered many times. However, if you’re anything like me, you would like to know how to control the actual arrangement is done by Excel. Maybe you’d like the window on the left to be the “before” worksheet and the worksheet on the right …

View multiple worksheets at the same time

Sometimes you would like to view multiple worksheets at once. Maybe you have two worksheets to compare side-by-side or you are working on one worksheet where you need to reference another section at the same time. I've been in these situations before and it's nice to know that Excel offers ways to show multiple worksheet / workbooks in a nice ...

Merge Cells In Depth

Excel's Merge Cells feature offers a simple way to organize expand the space a single cell contains. If you have a summary page, for example, you may want to create a title for the display. Or on your data sheet, maybe you want to show that two columns belong to a specific group of data. Either way, Merge Cells in ...