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 10, 2019 | Excel Macros, Excel Tips & Tricks
Named ranges are cells, ranges, tables, formulas, or constant values that are represented with meaningful names, that are tied to their workbook reference (i.e. A1, B23, A1:B23). Using named ranges make formulas easier to read and maintain. In this guide, we’re...
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 and columns...
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 26, 2018 | Excel Macros, Resources
Excel, just like other Office products, supports comments. Although comments are helpful to add tips or other details into your spreadsheets, deleting them may become time consuming while trying to find and select all of them. In this article, we’re going to...
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...
by Ilker | Nov 15, 2018 | Excel Macros, Excel Tips & Tricks, Resources
Excel, just like other Office products, can detect URLs and email addresses, and turn them automatically into hyperlinks. While this can usually speed things up when creating workbooks, they can become nuisance when you don’t want them to be clickable links with...
by Ilker | Nov 13, 2018 | Excel Macros, Excel Tips & Tricks
Excel doesn’t automatically update any external links in your workbooks and this can become a hassle if it’s something happening frequently. In this article, we’re going to show you how to make Excel update links automatically using VBA. How to make...
by Ilker | Nov 12, 2018 | Excel Macros, Excel Tips & Tricks
Managing and removing named ranges in Excel can be a challenging task as you would have to do this one by one for each field. We’re going to show you how to delete named range Excel using VBA with one click.How to delete named range ExcelEach named range is an...