Writing macros in Excel is a great way to automate a a bunch of tasks. We have shown you before how to automate Excel with macros or VBA, but this post is about letting you see a progress bar while they run. As you probably already know, when you run macros in Excel you don’t really know when they are done or crashed, until its too late. Having a progress bar while running macros in Excel would be a big help. Here is how you create a user form that shows a progress bar for your macros.
Making a table is a great way to organize your data in Microsoft Excel. This feature is only available for Excel 2007 and up. If you still have an older version of Excel, you can use ranges to organize your data. But you will not get the added benefits for having a nice table. Here […]
If you spend a lot of time copying and pasting data from on Excel sheet to another you might want to think about automating the process. Automating task in Excel can be easily done by using a macro or with some VBA code. For this tutorial we will show you how to copy cell value in VBA […]
Microsoft Excel has many functions. One of them is called the ISERROR function. With ISERROR you can return a true or false value if there is an error or not. Here is how to use the ISERROR function in Excel 2010.
Love using Excel as a financial tracking spreadsheet or a calculator? Here is an easy way to calculate a loan payoff in Excel 2010
Here is a quick Excel how to! Remove those hidden shapes or objects form your workbook to help speed it up or just reduce its file size.
Have you ever had the need to print each column header in Excel 2010 on every page in the workbook, here is how you can do this.
When working with a workbook or spreadsheets you might want to print first row on every page in Excel 2010. Here is how to do this.
We have shown you how to get the Column number from Excel 2007 using the Column Function. But what if you need the actually letter for a macro in your VBA code? Here is how you do it. Here is the Code, don’t worry I’ll explain in a second: Sub Convert_Column_Letter() Dim MyColumn As String, […]
Excel Column Function lets you return the number associated with a Column. For example Column(B2) would return 2 since B is the 2nd column.