by Ilker | Nov 21, 2019 | Excel Tips & Tricks
A loop is an essential concept for any programming language, and VBA follows the same approach. You can use loops to repeat an action until a specified condition is reached, or move through objects in a group, e.g. all worksheets in a workbook. A loop is an essential...
by Ilker | Jul 2, 2019 | Excel Macros, Excel Tips & Tricks
Macros in Excel are code blocks that you can run in your workbooks to process a batch of commands. Macros are great for automating repetitive tasks such as copying or removing data from specific cells. However, macros can be daunting for new users. Creating a macro is...
by Ilker | Jun 28, 2019 | Excel Tips & Tricks
The Excel Developer tab is a Ribbon tab which contains a number of tools aimed towards advanced features of Excel such as VBA, add-ins, form and ActiveX controls. Although you can access the VBA Editor with the shortcut (Alt+F11), the Developer tab in the Ribbon also...
by Ilker | Jun 25, 2019 | Excel Tips & Tricks
Excel can get the stock market data from 60 different stock exchanges around the world. However, this information will not refresh automatically, and currently you need to refresh stock data manually, or write a VBA code to automate the process. In this article, we...
by Ilker | Feb 13, 2019 | Excel Macros, Excel Tips & Tricks
Excel doesn’t always update the range of cells you’ve used in worksheets when you modify them. This can result in a larger file size and have performance impacts, even after you clear cell contents. The easiest way to fix this is by deleting the blank rows...
by Ilker | Dec 25, 2018 | Excel Tips & Tricks
You might want to hide the named ranges in your workbook to prevent your users to tamper with your calculations. In this article, we’re going to show you how to hide named ranges in Excel using VBA. How to hide named ranges using VBANamed ranges are objects in a...
by Ilker | Dec 5, 2018 | Excel Macros, Resources
Getting rid of specific cells could prove challenging if you were to do it manually. In this article, we’re going to show you how to make Excel delete rows with value of your choosing, using VBA. You can remove cells with certain strings or create an input cell...
by Ilker | Nov 20, 2018 | Excel Tips & Tricks, Resources
Excel, just like other Office products, supports AutoShapes. Although Excel shapes are nice to have for presentation purposes, getting rid of them may become time consuming if your workbook is cluttered with them. This article shows you how to delete Excel shapes...
by Ilker | Nov 16, 2018 | Excel Macros, Excel Tips & Tricks, Resources
Excel, just like other Office products, supports inserting pictures of various formats into your workbooks. However, deleting them may be time consuming in large workbooks if you’re trying to find and delete every single image manually. Let us show you how to...
