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.
This tutorial will demonstrate how to lock a cell after data entry using Excel VBA with a message box notification before locking. So users will not be able to ...
This tutorial will demonstrate how to create a project timeline in Excel. Suppose, we are managing a small project. To manage the project we want to create a ...
This tutorial will illustrate how to use Excel macro to send an email automatically. We can configure our mailing feature using VBA macros. So, using the VBA ...
This tutorial illustrates how to unprotect an Excel sheet if we forgot the password. To keep our worksheet or workbook confidential, we set a password. The ...
This tutorial will demonstrate the methods to calculate conditional weighted average with multiple conditions in Excel. While calculating the weighted average ...
In this article, we will demonstrate different examples of using Excel VBA code to import a CSV file without opening it. Sometimes, we get our dataset in CSV ...
This tutorial demonstrates how to split text by a number of characters in excel. When working with a dataset in Excel, the format can vary depending on the ...
Method 1 - Manual Approach to Split Excel Sheet into Multiple Files Method 1.1 Using Copy and Paste Options In the following dataset, we have sales ...
In this tutorial, we will demonstrate how to extract numbers after a specific text in Excel. In many instances, we need to extract a specific part of a string ...
In this tutorial, we will demonstrate how to remove space after a number in Excel. While working on Microsoft Excel we are very likely to have additional ...
In this tutorial, we are going to explain how to generate a random number with mean and standard deviation in Excel. However, you might want to generate a ...
In this tutorial, we will demonstrate different examples of how to use multiple IF condition in excel. However, we may need to analyze multiple conditions at ...
In this tutorial, we demonstrate how to use VBA to insert a column with a name in Excel. While working in Microsoft Excel, we may sometimes need to add a ...
In this tutorial, we will explain different methods to generate a random 10 digit number in Excel. While working on a project in Microsoft Excel sometimes we ...
In this tutorial, we will demonstrate the use of Excel VBA to filter in the same column by multiple criteria. In Microsoft Excel using VBA to filter a dataset ...
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.
Contact | Privacy Policy | TOS
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
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.