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...
by Ilker | Nov 8, 2018 | Excel Macros, Excel Tips & Tricks
This article shows you How to prevent Save As with VBA.You can control your workbook’s events like opening, closing or saving by VBA. Events for Excel’s native objects are built in and ready to use. To prevent Save As event, the address is Workbook...
by Ilker | Oct 26, 2018 | Excel Macros, Excel Tips & Tricks
Be it for troubleshooting formula errors or data integrity, you might find yourself trying to identify those cells going through the entire workbook. In this article we’re going to show to find in Excel if cell is blank using VBA and automate this process....
by Ilker | Oct 18, 2018 | Excel Macros, Excel Tips & Tricks
More often than not, to save time or for the sake of laziness, people enter data in all lowercase or all uppercase. Transforming this type of data into the proper format can be a serious headache. Let us show you how to make Excel capitalize first letter using VBA to...
by Ilker | Oct 18, 2018 | Excel Macros, Excel Tips & Tricks
Is changing the all letters to lowercase manually taking too much time? Let us show you how to convert selection to Excel lowercase using VBA and automate this process. Both Excel and VBA have a function to do this. Both functions use a single argument which is the...
by Ilker | Oct 12, 2018 | Excel Macros, Excel Tips & Tricks
Changing lowercase characters into uppercase is a pretty tedious task if you’re doing it manually. In this article, we’re going to show you how to make Excel change case to uppercase using VBA Both Excel and VBA have a function to do this. Both use a...
