Filtering is a common everyday action for most Excel users. Whether using AutoFilter or a Table, it is a convenient way to view a subset of data quickly. Until the FILTER function came to Excel, there was no easy way to achieve this with formulas. When Microsoft announced the changes to Excel’s calculation engine, they also Read More
Month: March 2021
How to Use DATE and EOMONTH to Get First Day and Last Day of the Month and Year.
On this page, you will find some formulas to calculate specific days automatically. Building specific dates, such as the first or last day, is always a very complex task, in Excel or any other software. The function TODAY has been used in all the examples but you can replace it with your own date value. Read More
How to Use the MONTHNAME Function (VBA)
This Excel tutorial explains how to use the Excel MONTHNAME function with syntax and examples. Description The Microsoft Excel MONTHNAME function returns a string representing the month given a number from 1 to 12. The MONTHNAME function is a built-in function in Excel that is categorized as a Date/Time Function. It can be used as a VBA function Read More
Three Best Ways to Find Last Row(Non-blank) and Column Using VBA
Finding last used row and column is one of the basic and important task for any automation in excel using VBA. For compiling sheets, workbooks and arranging data automatically, you are required to find the limit of the data on sheets. This article will explain every method of finding last row and column in excel Read More
How to Turn off the Camera Sound on iPhone
What to Know Disable the camera shutter sound using the Live Photo feature. Go to Settings > Camera > Preserve Settings and turn on Live Photo. Mute the phone’s ringer. To mute, toggle the switch on the left side of the phone. Access Control Center and lower the volume. Swipe down from the upper-right corner of the screen and move the volume Read More
Excel VBA How to Clear All Filters
AutoFilterMode will be True if engaged, regardless of whether there is actually a filter applied to a specific column or not. When this happens, ActiveSheet.ShowAllData will still run, throwing an error (because there is no actual filtering). I had the same issue and got it working with This seems to prevent ShowAllData from running when there is Read More