User Posts: Yousuf Khan
0
[Fixed!] Excel Map Chart Not Working (11 Possible Solutions)
0

Excel Map Chart is an effective tool for delivering insights and displaying data. However, occasionally customers encounter problems with the Map Chart not ...

0
How to Create Electricity Cost Calculator in Excel (with Easy Steps)
0

Microsoft Excel is very useful to build a power energy cost calculator. We can use Excel formulas to create the calculator efficiently saving a lot of time and ...

0
How to Fix When Excel Not Responding Without Losing Data
0

Has your Microsoft Excel file suddenly ceased to function and begun to display the Excel Not Responding error message? Further, while attempting to operate on ...

0
How to Create Fixed Rate Mortgage Calculator in Excel
0

Microsoft Excel computes costs associated with our mortgages, such as interest and monthly payments, which is one of its powerful features. If you are a little ...

0
How to Find Minimum Value That Is Greater Than 0 in Excel
0

If you are hoping to find the minimum value greater than zero in your large Excel dataset, you have come to the right place. As business analysts, we use Excel ...

0
How to Create Maternity Leave Calculator in Excel
0

Microsoft Excel is a powerful software. We use Excel formulas and functions in our education, business, and workplaces. Moreover, using Excel, HR can track ...

0
How to Create Fully Automatic Invoice in Excel (with Easy Steps)
1

Microsoft Excel is a powerful tool. We use Excel Functions in our education, business, and financial analysis. Furthermore, as bookkeepers, we have to build ...

0
How to Use VBA Intersect Method in Excel (4 Practical Examples)
0

The entire Excel application is under VBA Application Object. Moreover, Excel provides different application methods like the VBA Intersect method to return a ...

0
How to Use IF Function with OR and AND Statement in Excel
0

By checking for a condition and delivering a result if it is TRUE or FALSE, the IF function enables us to logically compare a value to what we anticipate. What ...

0
How to Use NOMINAL Function in Excel
0

Microsoft Excel is a handy software. We use Excel functions for our education, business, and financial analyses. Moreover, in light of the effective rate and ...

0
How to Insert Leader Lines into Doughnut Chart in Excel
0

Microsoft Excel is a powerful software. We create different charts with leader lines in our business analyses and presentations. Unfortunately, Excel does not ...

0
How to Calculate Partial Correlation in Excel (3 Suitable Ways)
0

Microsoft Excel is a powerful software. We use Excel functions and features for our educational, business, and other mathematical analyses such as stock ...

0
How to Find Average with Blank Cells in Excel (4 Easy Ways)
0

There are several distinct Microsoft Excel functions for determining the average of integer values. Additionally, there is a quick non-formula way. This ...

0
How to Hide Filter Arrows from Pivot Table in Excel (3 Easy Ways)
0

While generating a Pivot Table in Microsoft Excel, various Filed Buttons including Filter Arrows appear automatically at the table headers. As a user, we might ...

0
[Fixed!] EDATE Function Not Working in Excel
0

Businesses use Excel functions like EDATE for a variety of tasks, including tracking data records, scheduling, and producing analytical reports. If using Excel ...

Browsing All Comments By: Yousuf Khan
  1. Dear BZOIRO,

    Yes, you can modify the SearchAll function in the given VBA code to search for each word in the cells separately. I have added the modified code in the Excel file below. This modification splits the search value into words using the Split function and loops through each word to find it in the range. If all words are found, the function merges the found ranges into a single range and thoroughly returns it. If any of the words are not found, the function exits and returns Nothing. Here’s how to use this for your case:

    1. Initially, assign Macro “SearchMultipleSheetsIndividually” in the Search command box and click Run.
    Assigning Macro
    2. Afterward, type the word you wish to look for. Also, don’t forget to use the Wildcards (*, ? etc) while searching. For instance, if you wish to look for a cell of 3 words and has “Emily” in the middle, type *Emily* and then perform searching. Alternatively, if it happens to be the first word, try Emily*.
    Search Results

    Download the Excel file to get the modified VBA code and practice by yourself. I hope it works for you.
    https://www.exceldemy.com/wp-content/uploads/2023/01/Search-Box-for-Multiple-Sheets.xlsm
    Best Regards,
    Yousuf Khan (ExcelDemy Team)

  2. Dear LUNDER,

    My understanding of your statement implies that there is an issue with the calculations being performed in Microsoft Excel, specifically with the trigonometric functions cosine (cos), cosine (cos), and sine (sin) for certain angle values.

    Further, I concur that the error seems to affect the precision of the results starting from the 17th decimal place, which makes the calculated values for the angles cos 90°; cos 270°; sin 180° to be inaccurate. However, it is important to note that the internal representation of floating-point numbers in computers can lead to inaccuracies, especially when working with very small or large numbers, or when performing multiple mathematical operations.

    In these cases, you can take the following steps to resolve this issue.

    1. Use the RADIANS function to convert the angle from degrees to radians before evaluating the trigonometric functions.
    2. Increase the number of decimal places used in the calculations by using the ROUND or ROUNDUP functions.

    Best Regards,
    Yousuf Khan (ExcelDemy Team)

  3. Dear TONY,

    It’s possible that the delay is due to the amount of data being processed by the validation formula. To reduce the delay, you can try the following:

    1. Turn off screen updating and calculation during the execution of the macro to reduce the time it takes to display the changes.
    2. Consider using a different method for data validation, such as using a custom function or a Macro.

    As requested, I have added a revised version of the VBA code with the optimizations under Private Sub Worksheet_Change in Module 3. I hope, these modifications will improve the performance of the code, as it minimizes the amount of visual updates that occur during the process. This will reduce the amount of time it takes for the changes to be made in the sheet as you type in. Download the Excel file and use the desired code.
    https://www.exceldemy.com/wp-content/uploads/2023/01/Multiple_Selection_from_Drop-Down.xlsm
    Best Regards,
    Yousuf Khan (ExcelDemy Team)

  4. Hello ASRA,

    The Data Type option in the Data tab in Microsoft Excel is available in both the online and offline versions of Excel.

    The offline version of Microsoft Excel is part of the Microsoft Office suite, which can be purchased and installed on your computer. Once you have installed Microsoft Office, you can access Microsoft Excel from the start menu or by double-clicking on an existing Excel file on your computer. The Data Type option in the Data tab will be available in the Excel application after installation. I hope this helps.

    Regards,
    Yousuf Khan (ExcelDemy Team)

  5. Dear GORAN ZORIC,

    Thank you for your comment! We are glad you took the time to review the article. Regarding the trade direction (BUY or SELL), it is actually represented in the Long / Short (L/S) column in the trading journal template. The trade direction entry can be either a “Buy” (long) or “Sell” (short) and the template will automatically add this field after you enter your entry and exit prices. We apologize for any confusion and hope this clarifies the matter. Thank you for bringing this to our attention.

    Regards,
    Yousuf Khan (ExcelDemy Team)

  6. We apologize for the inconvenience. We are aware of the missing source reference and are working on updating the explanation. Further, we recommend using the code given before the explanation. Thank you for bringing this to our attention.

  7. Hello FAHIM,

    Yes, it is possible to highlight rows and columns of multiple active cells using conditional formatting in Microsoft Excel. To do so, you can use the following steps:

    1. Initially, select the cells you want to apply the conditional formatting to.
    2. Afterward, go to the Home tab and click the Conditional Formatting button in the Styles group.
    3. Later, choose New Rule from the drop-down menu.
    4. Next, select “Use a formula to determine which cells to format.”
    5. Meanwhile in the formula box, enter the following formula:
    =ROW()>=MIN(ROW($C$4:$F$10))
    6. Further, click the Format button and select the fill color you want to use.
    7. Lastly, click OK to close the Format Cells dialog box.
    This approach uses a relative reference for the row and column in the formula, allowing the conditional formatting to adjust automatically as cells are selected.

  8. Hello RUDOLF,

    Thank you for bringing this to our attention! Yes, checking the Data Validation is a good suggestion to find and remove external links in Excel. Although, external links in Data Validation are not directly removable through Data Validation itself. However, by updating the source data for the Data Validation drop-down list, you can remove any external links that may be present.

    Regards,
    Yousuf Khan (ExcelDemy Team)

  9. Hello ADITYA,

    You’re welcome! We are glad to hear that you found the solution to your issue. Unprotecting the workbook can indeed resolve the issue of being unable to set the visible property of the Worksheet class. It’s great to see that your dynamic VBA code is working as expected. Let us know if there’s anything else we can help with.

    Regards,
    Yousuf Khan

  10. Hi MICHAEL,

    The errors you’ve mentioned could indicate that the workbook is either very hidden or corrupted. There are two levels of worksheet hiding: hidden and very hidden. From a user’s perspective, the difference is that a very hidden sheet cannot be made visible through the Excel user interface, and the only way to unhide it is with VBA.

    Since you’ve used VBA to work with the worksheets and they still appear hidden, you can try a different VBA code to check if they’re very hidden and unhide them. Here’s the VBA code to unhide all very hidden sheets:

    Sub UnhideVeryHiddenSheets()
      Dim wks As Worksheet
      For Each wks In Worksheets
          If wks.Visible = xlSheetVeryHidden Then wks.Visible = xlSheetVisible
      Next
    End Sub

    Note: This code only works for very hidden sheets, not worksheets that are hidden normally. If you want to display all hidden sheets, use the code below.

    Sub UnhideAllSheets()
      Dim wks As Worksheet
      For Each wks In ActiveWorkbook.Worksheets
        wks.Visible = xlSheetVisible
      Next wks
    End Sub

    Give it a try and let me know if it works.

    Best Regards,
    Yousuf Khan

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo