User Posts: Alif Bin Hussain
0
How to Use Excel VBA to Customize Ribbon (with Easy Steps)
0

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 ...

0
Excel VBA to Split String by Delimiter (9 Examples)
0

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 ...

0
Automatic Uppercase in Excel VBA (2 Examples)
0

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 ...

0
VBA Array Size Limit in Excel (5 Different Cases)
0

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 ...

0
How to Deselect in Excel VBA
0

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 ...

0
Excel VBA to Set Vertical Alignment (5 Suitable Examples)
0

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 ...

0
How to Use Excel VBA Like Operator (7 Suitable Examples)
0

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 ...

0
How to Use Excel VBA to Move Files
0

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 ...

0
[Fixed!] Excel VBA InStrRev Not Working
0

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. ...

0
Excel VBA to List Files in Folder and Subfolders 
0

Managing large amounts of data in Excel can be very challenging, especially when it comes to locating and organizing files scattered across multiple folders ...

0
How to Limit Cell Value in Excel (7 Suitable Examples)
0

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 ...

0
Excel VBA Array of Strings (4 Examples)
0

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 ...

0
Excel VBA Select Case True
0

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 ...

0
How to Create an Export Price Calculator in Excel
0

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 ...

0
How to Navigate to a Named Range in Excel (3 Easy Ways)
0

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, ...

Browsing All Comments By: Alif Bin Hussain
  1. Hello FAIS,

    Follow these steps to get your desired result.

    • You can use the following formula to calculate the time required to get the desired salary. This formula will give you the result in years only.

    =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%).

    • If you want the results to be in years and months, use the formula given below.

    =INT(C8)&" years " & INT(MOD(C8*12,12))&" months"

    Here, C8 refers to the required time in years.

    • You can set up your Excel worksheet like the following image given below to get the desired result.

  2. Hello Claire,

    Follow these steps to make the stacked bar charts of Likert scales.

    • First, select the range B4:G10.
    • Then go to,

    Insert >> Charts >> 100% Stacked Column

    • As a result, the chart will look like the following image.

  3. 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.

  4. Reply Avatar photo
    Alif Bin Hussain Mar 9, 2023 at 5:38 PM

    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.

    • In this example, we want to attach a file named Attachment.pdf. The path directory for the file is D:\Exceldemy\.

    How to Send Automatic Email from Excel to Outlook with Attachment

    • First, download the workbook provided in this article and open it.
    • Next, add a new column (H) and write the file names you want to attach to the email. Make sure to write the file extension.

    How to Send Automatic Email from Excel to Outlook with Attachment

    • Then, open the code module and write the following code.

    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
    How to Send Automatic Email from Excel to Outlook with Attachment

    • After writing this code, go back to the excel sheet.
    • Then, select one or more names and click on the button.

    How to Send Automatic Email from Excel to Outlook with Attachment

    • As a result, Microsoft Outlook software will open and you will find the email already written with the attached file. You can just click send to send the Email.

    How to Send Automatic Email from Excel to Outlook with Attachment

  5. 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.
    make an eisenhower matrix in excel
    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.
    make an eisenhower matrix in excel
    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.
    make an eisenhower matrix in excel

    I hope this solves your problem. Please let us know if you face any other issues.

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo