Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Below is the code I am using. The code is designed to hide zeros. Let me
know if anyone has any ideas or suggestions why it is not working. Thanks in advance. Mike C Sub Toggle_Suppresion() Dim i As Integer Dim n As Integer Dim wkb As Workbook Dim wks As Worksheet Dim fim As Worksheet Dim rng As Range Dim absRowTot As Double Dim topCell As Integer 'The first Row in the report with data (must be changed accordingly) Dim bottomCell As Integer 'Bottom Row in the report (set automatically) Dim absRowTotColumn 'The numeric column that has the absolute value sumation topCell = 8 bottomCell = ActiveSheet.UsedRange.Rows.Count absRowTotColumn = 20 Set wks = ActiveCell.Worksheet Set fim = ActiveSheet Application.ScreenUpdating = False 'fim.Select 'Rows(topCell & ":" & bottomCell).Select 'Selection.EntireRow.Hidden = False For i = topCell To bottomCell Step 1 absRowTot = fim.Cells(i, absRowTotColumn).Value If absRowTot = 0 Then For n = i To (i) Rows(n).Select Selection.EntireRow.Hidden = True Next End If Next fim.Select Range("a1").Select Application.ScreenUpdating = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
runtime error 13 - type mismatch error in Excel 97 on Citrix | Excel Programming | |||
xpath error? Runtime Error 13 type mismatch | Excel Discussion (Misc queries) | |||
xpath error? Runtime Error 13 type mismatch | Excel Discussion (Misc queries) | |||
Runtime Error '13': Type mismatch | Excel Programming | |||
Runtime error 13 type mismatch ? | Excel Programming |