by Ilker | Jun 16, 2021 | Excel Tips & Tricks
Inserting new rows is the easiest way to add new fields into your worksheet area. Since Excel inserts rows by copying the formatting of the previous row, it is usually more practical than moving bottom cells to open up space for new data. Thanks to VBA, we can insert...
by Ilker | Apr 16, 2021 | Excel Tips & Tricks
How to shorten VBA code in Excel Shortening VBA code can make it much easier to read and maintain. Here, we mean shortening in the sense that some code blocks can be stacked or alternative statements can be introduced to make it more efficient. In this guide,...
by Ilker | Mar 26, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you 5 tips for VBA beginners in Excel and get you up to speed in no time! Saving macros – tips for VBA beginners Since the 2007 version, Excel has been differentiating between files containing macros based indicated by...
by Ilker | Mar 26, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to create index page of worksheets in Excel with hyperlinks. Using VBA, you can automatically update the hyperlinks after adding or removing sheets. Download Workbook First, you need to create a new sheet for the index....
by Ilker | Feb 25, 2021 | Excel Tips & Tricks
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...
by Ilker | Feb 17, 2021 | Excel Tips & Tricks
With Application.OnTime method, you can set Excel to run some VBA at a specific time, or repeatedly at set intervals. In this guide, we're going to show you how to run macro at a specified time in Excel. Download Workbook Application.OnTime VBA’s Application.OnTime...
by Ilker | Feb 16, 2021 | Excel Tips & Tricks
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...
by Ilker | Feb 2, 2021 | Excel Tips & Tricks
In finance, option pricing is a term used for estimating the value of an option contract using all known inputs. Monte Carlo Simulation is a popular algorithm that can generate a series of random variables with similar properties to simulate realistic inputs. In this...
by Ilker | Aug 31, 2020 | Excel Tips & Tricks
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...