Latest Posts From Alif Bin Hussain
Method 1 - Save Excel File as Zip File Change the extension of the Excel file. We have a sample Excel file with the extension xlsm. We want to change it to ...
Alif Bin Hussain
Method 1 - Use Split Function to Split String by Delimiter Use the Split function to split strings using a delimiter. We have a string with Sales Rep names ...
The Excel VBA UCase Function VBA Ucase function is a built-in function used to convert text to uppercase. It takes strings as input and converts each letter ...
Array is an important feature that allows you to store and manipulate data. However, VBA has limitations on the size and dimension of an array. Exceeding these ...
How to Launch VBA Editor in Excel To access the Microsoft Visual Basic window, go to the Developer tab and click on Visual Basic. You can also open ...
This is an overview. Syntax: expression.VerticalAlignment Expression is a variable that represents a cell-format object. These are common ...
Excel VBA Like operator is a very useful feature that allows you to match one or more specific letters or numbers within a string. In this article, we will ...
A File System Object (FSO) is an object in VBA that provides a way to work with files and folders on a computer’s file system. It allows VBA code to create, ...
![[Fixed!] Excel VBA InStrRev Not Working](https://www.exceldemy.com/wp-content/uploads/2023/05/3.-Excel-VBA-InstrRev-Not-Working-because-of-syntax-error.png?v=1697520377)
Looking for a way to get rid of the Excel VBA InStrRev Not Working issue? If you are, you’ve come to the right place. This problem can occur for many reasons. ...
This is an overview. Key Concepts i. Dir Function The Dir function returns the first file name in the specified folder. ii. File System ...
Introduction to VBA Array Arrays are powerful tools for managing data, and they allow you to group related values under a single variable name. Here are the ...
VBA Select Case True is a very useful statement while working with multiple conditions. This statement is more concise and presents the conditions in a ...
Method 1 - Calculate Free on Board Insert the price of the following four types of expenses. Value of the goods Cost of handling carriage before ...
Sometimes we change the names of cells and ranges as per our need for various purposes in Excel. While working with a large dataset with lots of named ranges, ...
Here’s an overview of the offset mortgage calculator we’ve prepared for this article. Introduction to Offset Mortgage Offset mortgages offset the ...
See Our Reviews at
Hello FAIS,
Follow these steps to get your desired result.
=LN(C6/C4)/LN(1+C5)In the formula, C6 refers to the desired salary (75000000), C4 refers to the current salary (307584) and C5 refers to the increment percentage (10%).
=INT(C8)&" years " & INT(MOD(C8*12,12))&" months"Here, C8 refers to the required time in years.
Hello Tom,
The upward arrow between C9 and C10 in the formula indicates the exponent operation of mathematics. In the formula, C9 raised to the power of C10 is written as C9^C10. A simple example would be “Two Squared” which is written as 2^2 = 4, where 2 is raised to the power of 2, resulting in 4.
Hello Claire,
Follow these steps to make the stacked bar charts of Likert scales.
Insert >> Charts >> 100% Stacked Column
Hello Torsten,
Thank you for bringing this matter to our attention. We will look into the VBA function to see if it can be updated to minimize the deviation of the orange line from the given points.
Besides, I would like to address your concern regarding interpolation methods. There are some interpolation methods that go through all the given points such as Lagrange interpolation or polynomial interpolation etc. However, interpolation method such as cubic spline interpolation does not necessarily pass through all the given data points.
Hello SANJAY DANGI,
Thank you for reaching out. You can add attachment to the email in the first method easily. Follow these steps to do it.
Sub ExcelToOutlookSR() Dim mApp As Object Dim mMail As Object Dim SendToMail As String Dim MailSubject As String Dim MailBody As String Dim FileName As String Dim Path As String 'Declare variable for file path Path = "D:\Exceldemy\" 'Set file path For Each r In Selection SendToMail = Range("C" & r.Row) MailSubject = Range("F" & r.Row) MailBody = Range("G" & r.Row) FileName = Range("H" & r.Row) 'Get file name from H column Set mApp = CreateObject("Outlook.Application") Set mMail = mApp.CreateItem(0) With mMail .To = SendToMail .Subject = MailSubject .Body = MailBody .Display .Attachments.Add (Path & FileName) 'Add attachment End With Next r Set mMail = Nothing Set mApp = Nothing End SubHello Theo,
Follow these steps to adjust ranges to make a longer list without any error.
1. First, to make the task list longer, select cells H13 through J13. Then drag the fill handle down to add new task.
2. In this example, we added five new tasks. Therefore, the new ranges for column H, I and J are H6:H18, I6:I18 and J6:J18 respectively.
3. Then select cell D6 and change the ranges of H,I and J cells in the formula bar and press Enter. After that, Autofill formula up to cell D9.
4. Similarly, change the formula ranges for other cells as well.
5. Finally, you can see in the following figure that the formula is working properly.
I hope this solves your problem. Please let us know if you face any other issues.