Hello,
I am having trouble with getting a VBA code to work that automatically updates a filter on a column that is removing rows with the value "0". I have a large range of cells that are narrowed down to everything that isn't 0, and in that range the cells displaying 0 will have values later on that I want to automatically display without user input. I have found many codes but none work. Below is the latest one I tried:
Private Sub Worksheet_Calculate()
If Me.FilterMode = True Then
With Application
.EnableEvents = False
.ScreenUpdating = False
End With
With ActiveWorkbook
.CustomViews.Add ViewName:="Mine", RowColSettings:=True
Me.AutoFilterMode = False
.CustomViews("Mine").Show
.CustomViews("Mine").Delete
End With
With Application
.EnableEvents = True
.ScreenUpdating = True
End With
End If
End Sub
This issue seems simple so it's quite frustrating. Any help would be greatly appreciated!
I am having trouble with getting a VBA code to work that automatically updates a filter on a column that is removing rows with the value "0". I have a large range of cells that are narrowed down to everything that isn't 0, and in that range the cells displaying 0 will have values later on that I want to automatically display without user input. I have found many codes but none work. Below is the latest one I tried:
Private Sub Worksheet_Calculate()
If Me.FilterMode = True Then
With Application
.EnableEvents = False
.ScreenUpdating = False
End With
With ActiveWorkbook
.CustomViews.Add ViewName:="Mine", RowColSettings:=True
Me.AutoFilterMode = False
.CustomViews("Mine").Show
.CustomViews("Mine").Delete
End With
With Application
.EnableEvents = True
.ScreenUpdating = True
End With
End If
End Sub
This issue seems simple so it's quite frustrating. Any help would be greatly appreciated!
