Hides Rows Whose Totals Are Equal To Zero Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Sub sıfırgizle() For Each rngRow In ActiveSheet.UsedRange.Rows If Application.Sum(rngRow) = 0 Then rngRow.EntireRow.Hidden = True End If Next rngRow End Sub Report problem with this macro This macro does not work. There's an error in the code. Other You can write your comments about the error in the box below. Report error ALL MACROS Youtube Channel The following macros may be useful for you. Similar Results NoMacro Name 1 hides rows whose totals are equal to zero 2 excel operators hk 3 convert double and single lines into different colors and designs (one line is bold and the other line is normal) 4 hides blank lines on a sheet / page 5 Hides empty rows in column c 6 adding two lines and removing total 7 Insert multiple rows 8 to delete sales with faulty cells 9 Hides empty rows in column a 10 prints all sheet / pages with data or scans but does not print 11 hides above rows with data 12 a3: prints data between cells f15 13 prints cells with data 14 printout by defining a cell 15 makes the print area a3: f15 and selects and prints the line to repeat 16 Â Pivot Table These codes help you make and manage some changes to pivot tables in a flash. Hide Pivot Table Subtotals: If you want to hide all subtotals, simply run this code. first make sure that you select a cell from the pivot table and run this macro. 17 Find and select the remaining cell in the value between 2 selected numbers 18 Automatically resize row width when cells are merged 19 shows sheet / page2 hides (2 clicks in sequence) 20 Copy and paste cell values by shortcut