İf A1 İs 0, Hide A10: A20 İf Not Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Private Sub Worksheet_SelectionChange(ByVal Target As Range) If [a1].Value = 0 Then Rows("10:20").EntireRow.Hidden = True Else Rows("10:20").EntireRow.Hidden = False End If 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 if a1 is 0, hide a10: a20 if not 2 if a1 is 0, show between 10 and 20 rows if not 3 deleting the menu bar and creating a custom menu 4 write the days of this month to the right write the day to the child cell and color the weekends 5 inserts months as sheet / pages Specifies days in detail 6 specifies in detail how many formulas are in the book (on new sheet / page) 7 list formulas on new sheet / page 8 add a cell value to a comment 9 search combobox change 10 Hide or show pivot table fields according to a specific criterion 11 if you enter data between a1-a20 12 excel operators hk 13 c10 if a1 is 0: hide if c20 show 1 14 add time as menu (most reliable) 15 send alert e-mail from microsoft outlook 16 assigns date to the next line when data is entered in certain cells on the sheet / page 17 I want to throw the full cells in row with text between a1: an1000 into listbox 18 cell-related codes 19 Â 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. 20 find and list them in a message