Sometimes a user might need a custom ribbon if he wants to have quick access to the macros and commands he uses frequently. Excel allows users to customize ...
If you are looking for a way to split string by delimiter using VBA code in Excel, you have come to the right place. In Excel, you can easily split strings ...
Users have the flexibility to insert text in their preferred case. However, you might need the input to be only in uppercase. For such cases, you can use ...
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 ...
Sometimes a user might need to deselect a cell, range, or object to remove focus from a particular cell, range, or object after performing a task or to clear ...
Sometimes a user might need to change the vertical alignment of a cell or cells to enhance the appearance of a dataset. One of the ways to change the vertical ...
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 ...
Moving files from one folder to another is a very easy task as it can be done manually by using a mouse and keyboard within seconds. However, if someone ...
Looking for a way to get rid of Excel VBA InStrRev Not Working issue? If you are, you’ve come to the right place. This problem can occur for so many reasons. ...
Managing large amounts of data in Excel can be very challenging, especially when it comes to locating and organizing files scattered across multiple folders ...
Sometimes it becomes necessary to receive input from users in Excel cells and it is important to ensure that the entered value by the user is valid. In order ...
If you need to store and manipulate a list of your text values in VBA code, string arrays can be very useful. A string array can store multiple elements of ...
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 ...
If you need to calculate the export price of your products, using Excel can be very handy. If you have to do it on a regular basis, you might need your own ...
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, ...
- 1
- 2
- 3
- 4
- Next Page »
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 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 Sub
Hello 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.