Mukesh Dipto

About author

Mukesh Dipto is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including Rhino3D, Maxsurf C++, AutoCAD, HTML, CSS, JavaScript, and WordPress. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content all about Excel and VBA. You'll find him reading books, travelling, and enjoying movies and TV series outside work.

Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.Sc in Naval Architecture & Marine Engineering, BUET.

Expertise

Microsoft Word, Excel & VBA, PowerPoint, Microsoft Power BI, AutoCAD, Rhinoceros, HTML, CSS, JavaScript, WordPress

Experience

  • Resource Person at Directorate of Primary Education, Bangladesh, Dhaka.

Research

  • Maritime risk assessment of LNG carrier in Bangladesh using Fuzzy Logic Approach.

Latest Posts From Mukesh Dipto

0
How to Calculate MTD (Month to Date) in Excel (3 Methods)

In this tutorial, we will demonstrate how to calculate MTD (Month to Date) in Excel. Microsoft Excel offers a variety of options for calculating MTD depending ...

0
Excel VBA to Select Used Range in Column (8 Examples)

This tutorial will demonstrate 8 examples of using VBA to select the Used Range in a column in Excel. Generally, the UsedRange property in Excel represents the ...

0
VBA to Loop Through Rows in Range in Excel (6 Examples)

In this tutorial, we will cover how to use VBA to loop through rows in range in excel. We utilize loops to prevent doing the same thing over and over again. ...

0
How to Remove Text between Two Characters in Excel (3 Easy Ways)

In this tutorial, we will explain how to remove text between two characters in Excel. Suppose you are working with a list of text strings where you want to ...

0
[Fixed!] This Workbook Contains Links to One or More External Sources That Could Be Unsafe

In this tutorial, we will cover how to fix the ‘This workbook contains links to one or more external sources that could be unsafe’ error. When we open a ...

0
How to Return Row Number of a Cell Match in Excel (7 Methods)

If you're working with huge datasets and extensive search functions, you might need to locate a specific row to find additional information for a given object. ...

0
How to Hide Formula in Excel without Protecting Sheet (2 Methods)

This tutorial will explain how to hide the formula in Excel without protecting the sheet. While working in Microsoft Excel we might need to share our Excel ...

0
FIND Function Not Working in Excel (4 Reasons with Solutions)

In this tutorial, we will explain the reasons for the problem of why the FIND function in excel is not working. In Microsoft Excel, the FIND function is used ...

1
[Fixed!] Formula Result Showing 0 in Excel (3 Solutions)

In this tutorial, we will demonstrate how to fix the problem of the formula result showing 0 in Excel. While working in Excel we might need to add some values ...

0
How to Apply Multiple Data Validation in One Cell in Excel (3 Examples)

In this tutorial, we will demonstrate how to apply multiple data validation in one cell in Excel. If you work regularly on Microsoft Excel it may sound very ...

0
How to Use Excel Formula to Find Last Row Number with Data (2 Ways)

In this tutorial, we will demonstrate how to use an Excel formula to find the last row number with data. While working in Microsoft Excel we might need to know ...

0
How to Combine Rows from Multiple Sheets in Excel (4 Methods)

In this tutorial, we will demonstrate different methods of how to combine rows from multiple sheets in Excel. While working with multiple sheets in Excel, we ...

0
How to Find Blank Cells in Excel (8 Easy Ways)

This tutorial shows how to find blank cells in Excel. Sometimes we receive Excel files from someone or import those files from a database. To work properly we ...

0
How to Use Advanced Filter to Copy Data to Another Sheet in Excel

Usually, the advanced filter option allows us to extract data from a data range with respect to multiple conditions. We can use the advanced filter in Excel to ...

0
[Fixed!] Delete Sheet Not Working in Excel (2 Solutions)

In this tutorial, we'll look at how to fix the problem when delete sheet not working in Excel. While working with a workbook that consists of multiple ...

Browsing All Comments By: Mukesh Dipto
  1. Hello Ruby,
    Thanks for your query. If you do not want to see the formula for a blink then you have to do it by protecting the worksheet. You can try the following code:
    Sub HideFormulasDisplayValues()
    With ActiveSheet
    .Unprotect
    .Cells.Locked = False
    .Cells.SpecialCells(xlCellTypeFormulas).Locked = True
    .Cells.SpecialCells(xlCellTypeFormulas).FormulaHidden = True
    .Protect AllowDeletingRows:=True
    End With
    End Sub

  2. Thanks for your feedback sir.
    The range is (>=50 and <=80). In Excel COUNTIF function by default omit the upper end value.
    So, the formula is basically showing the result for the values less than 80.

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo