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
How to Make iPhone Camera Shoot JPEG Pictures Instead of HEIF
We’ll show you how you can change the iPhone camera default image file type so that the iPhone will shoot pictures in JPEG format again. We’ll also cover a trick for leaving HEIF image format enabled but have those HEIF images automatically convert to JPEG files upon transfer to a computer. The iPhone camera image Read More