User Posts: Mukesh Dipto
0
0
While working with a big dataset sometimes we need to know how to Freeze Columns in Excel as well as Rows, or both of a worksheet. It’s necessary to make a ...
Mukesh Dipto
- « Previous Page
- 1
- …
- 6
- 7
- 8
Browsing All Comments By: Mukesh Dipto
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.