How to split text with VBA in Excel

How to split text with VBA in Excel

Text to Columns feature can help you split text strings in Excel. Using VBA, you can make this process even faster. In this guide, we’re going to show you how to split text with VBA in Excel. Download Workbook Data In this example, we have rows of data...
How to refer a range or a cell in Excel VBA

How to refer a range or a cell in Excel VBA

In this guide, we’re going to show you how to refer a range or a cell in Excel VBA. VBA Basics Before diving into the code, let’s start with a cell or a range means in VBA. First, VBA is an object-based programming language, which means that the language refers...
How to copy sheet in Excel with VBA

How to copy sheet in Excel with VBA

You can easily copy sheets in Excel manually with a few simple mouse clicks. On the other hand, you need a macro if you want to automate this process. In this guide, we’re going to show you how to copy sheets in Excel with VBA. Download Workbook Before you start...
How to set an Excel expiration date

How to set an Excel expiration date

You may want to set an expiration date for a workbook and prevent access for when creating a trial application, or simply ensuring that the application data is up to date. Unfortunately, Excel doesn’t have a built-in tools to handle this scenario, but you can use VBA...
How to switch to Excel full screen mode

How to switch to Excel full screen mode

Excel’s toolbar and Ribbon contain many features and shortcut icons that are aimed for improving productivity. On the other hand, these icons actually take a lot of space in your screen. Thus, your work space becomes a bit more limited. A full screen, or...
How to Make Excel Show Formula Bar or Hide It

How to Make Excel Show Formula Bar or Hide It

By default, the formula bar is visible in Excel to allow you to see and enter formulas in the active cell. However, you may want to hide the formula bar either to limit user interaction with it, or to give your Excel workbook a compact look and feel. Alternatively,...