Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I get a Run-time error 40036 after the .Rows(STARTROW).Insert in this code
Public Sub HideBlanksAndZeros2() Const MYCOL As String = "J" Const STARTROW As Long = 8 Dim rng As Range Application.ScreenUpdating = False With ActiveSheet .Rows(STARTROW).Insert .UsedRange With Intersect(.Cells(STARTROW, MYCOL).Resize(Rows.count - _ STARTROW), .UsedRange) .AutoFilter Field:=1, Criteria1:="=", _ Operator:=xlOr, Criteria2:="=0" On Error Resume Next Set rng = .SpecialCells(xlCellTypeVisible) On Error GoTo 0 .AutoFilter Field:=1 End With End With If Not rng Is Nothing Then rng.EntireRow.Hidden = True ActiveSheet.Rows(STARTROW).Delete Application.ScreenUpdating = True End Sub Any clues as to why? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ActiveSheet.Paste (error) | Excel Worksheet Functions | |||
Run time error 40036 | Excel Programming | |||
If ActiveSheet = .. then - I get an error | Excel Programming | |||
Error 40036 when activating a sheet | Excel Programming | |||
Run-time error 40036 | Excel Programming |