VBA Runtime Error 1004 “Application-defined or Object-defined error”
The VBA Runtime Error 1004 can be caused by many things. In this article, I’ll show a few different situations and how to…
Tag: medium
Leave a Cell Blank if the Condition Is False
The following formula will check cell A1, and if the condition is False (value != 2) it returns blank, otherwise (value = 2)…
Text to Rows in Excel
There is an Excel tool that converts text to columns taking data from a single column and splitting it into multiple columns. But you won’t…
Highlight Duplicate Rows in Excel
Depending on the data you have in your worksheet you may use one of the following ways to highlight duplicate rows. Highlight duplicate…
Highlight a Cell With a Keyboard Shortcut
If you are looking for a keyboard shortcut to highlight a cell with a color, I have bad news for you, you won’t…
Filter Shortcut in Excel
In this lesson, I will show you how you can use keyboard shortcuts to manipulate filters in Excel. Create filters Take a look…