by Ilker | Nov 29, 2022 | Excel Tips & Tricks
Excel has rich resources on filtering as expected from a spreadsheet software. However, the functionality may lack fanciness in a business software, like filtering on-the-fly as users are typing. Fortunately, Excel has enough customization tools to add such a feature...
by Ilker | Nov 29, 2022 | Excel Tips & Tricks
Excel has rich resources on filtering as expected from a spreadsheet software. However, the functionality may lack of fanciness in a business software, like filtering on-the-fly as users are typing. Fortunately, Excel has enough customization tools to add such a...
by Ilker | Feb 21, 2022 | Excel Tips & Tricks
If you are working with multiple Excel files at once, you often find yourself dealing with warning messages when trying to close them. Although it is a good thing to be warned about saving to not lose changes in a workbook, it may become annoying quickly. Thanks to...
by Ilker | Sep 13, 2021 | Excel Tips & Tricks
Excel can spell check, but it's not as capable as the spell check in Word, nor is it automatic. Using VBA, you can automate the spell-checking process in your workbooks. In this guide, we’re going to show you how to spell check using VBA in Excel. Download Workbook...
by Ilker | Jul 30, 2021 | Excel Tips & Tricks
Numeric values are defined by data types like integer or byte. These data types are used for optimizing the processing and memory allocation in Excel. In this guide, we’re going to show you how to convert string into number in Excel VBA. Download Workbook Data types...
by Ilker | Jun 22, 2021 | Excel Tips & Tricks
Excel VBA allows you to open a workbook directly - all you need is the full path of the file, including the file name. However, locating and supplying the file path each time may can be tedious when working with multiple files. In this guide, we’re going to show you...
by Ilker | Jun 21, 2021 | Excel Tips & Tricks
by Ilker | May 28, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to create and name a worksheet with VBA in Excel. Download Workbook Syntax You can create and name a worksheet using the Sheets.Add and Worksheets.Add methods. Both methods work similarly and have 4 optional arguments and...
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,...