A Small Glich in the VBA code to Hide the formula cells.

December 9, 2014 at 04:56:01
Specs: Windows 7

I have used the VBA code from the site you mentioned


It works fine.. But as soon as i select a range of cells, the sheet halts. the selection pan freezes.... I think it has something to do with

If Target.Cells.Count = 1 Then
ElseIf Target.Cells.Count > 1 Then
Set rFormulaCheck = Selection.SpecialCells(xlCellTypeFormulas)
If Not rFormulaCheck Is Nothing Then

But since i am new to VB code.. i dont seem to find my way around this error..

Any advice will be appreciated..

Thanks alot..

See More: A Small Glich in the VBA code to Hide the formula cells.

Report •

December 10, 2014 at 09:56:26
Are you storing this code in the ThisWorkbook module as instructed?

I tested the code and it worked fine for me.

What makes you think that the problem is in the section of code that you quoted?

BTW...before posting VBA code in this forum, please click on the following line and read the instructions found via that link. Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question