Excel VBA Send Emails from Excel Through Outlook Set Reference to Microsoft Office Library We must send emails from Outlook. Since Outlook is an external object, we first need object reference to ‘Microsoft Outlook 16.0 Object Library.’ 1. In VBA, Go to Tools > References. You see the object reference library. In this window, […]
Excel VBA Send Emails from Excel Through Outlook Read More »
How to Add a New Worksheet in Excel (Easy Shortcuts) Excel worksheets must be used when dealing with MS Excel. An area with all the cells necessary for formula entry, chart insertion, report, and dashboard creation is known as a worksheet. There is just one worksheet present by default when you start a fresh Excel
How to Add a New Worksheet in Excel (Easy Shortcuts) Read More »
Excel Shortcut for Selected Entire Column (or Row) Working with Excel entails interacting with the rows and columns’ cells and ranges. Additionally, picking complete rows and columns is a regular activity when working with enormous datasets. There are several ways to pick a column or row in Excel, just like there are for the majority
Excel Shortcut for Selected Entire Column (or Row) Read More »
How Can I Get The Sheet Name In Excel? Simple Formula You might occasionally need to acquire the worksheet name while dealing with Excel spreadsheets. Although you may always manually enter the sheet name, if the name changes, nothing will change. Therefore, you can use a straightforward formula in Excel to obtain the sheet name
How Can I Get The Sheet Name In Excel? Simple Formula Read More »
Excel Count Sheets ( by using VBA) With Excel’s built-in functions and features, you can accomplish certain straightforward tasks using VBA that are not feasible. One example of such a task is counting the total number of sheets in the open workbook or any other open workbook on your system. In this article, I’ll demonstrate
Excel Count Sheets ( by using VBA) Read More »
Compile error when you edit a VBA macro in the 64-bit version Check VBA Version #If VBA7 Then Msgbox “64 bit Version” #Else msgbox “32 bit version #End If convert 32 bit VBA code into 64 bit VBA code Replace (Long) data type with (LongPtr) at all places in the scripts This is 64
the project code must be updated for use on 64-bit system Read More »
How Do I Create a Calendar That Is Interactive in Excel? Free Template An Excel calendar might be quite helpful if you prefer to build weekly or monthly schedules and plans. In this article I’ll demonstrate how to make an Excel calendar that automatically updates when the month or year value is changed. I’ll walk
How Do I Create a Calendar That Is Interactive in Excel? Free Template Read More »
How to Show Fractions in Numbers (Write Fractions in Excel) It could be difficult to get numbers to display as fractions in Excel. Excel will convert every fraction you try to insert into a cell into a date or a text string. This occurs due to Excel’s inability to handle fractional data types. Therefore,
How to Show Fractions in Numbers (Write Fractions in Excel) Read More »
How to Determine in Excel whether a Date Is Between Two Given Dates (Easy Formula): Excel data analysis frequently requires dealing with dates. Many Excel users frequently need to determine whether a date falls between two specified dates when working with dates. Determining whether a report submission date was within the specified dates or
How to Determine in Excel whether a Date Is Between Two Given Dates (Easy Formula) Read More »
Excel Date Comparison (Greater/Less Than, Mismatches) Working with dates is one area that frequently causes problems for Microsoft Excel users. This is mostly due to Excel’s flexible date formatting options. Therefore, even though you may mistakenly believe that two dates you see in Excel are the same when they contain different values (or vice
Excel Date Comparison (Greater/Less Than, Mismatches) Read More »