image-1

How to Use FILTER function in Excel

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

image-1

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

image-1

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

image-1

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

image-1

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

image-1

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