Hide All Row Columns Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Sub sat_sut_giz() If TypeName(ActiveSheet) "Worksheet" Then Exit Sub If Rows(Rows.Count).Hidden = False And _ Columns(Columns.Count).Hidden = False Then Columns.Hidden = True Rows.Hidden = True With ActiveSheet.UsedRange .Columns.Hidden = False .Rows.Hidden = False End With Else Columns.Hidden = False Rows.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 hide all row columns 2 Show All Rows and Columns: You can use this code to do this one at a time, rather than overwriting individual rows and columns. 3 hides all rows and columns 4 excel operators hk 5 prints all sheet / pages with data or scans but does not print 6 Hide number of columns from 1 to 26 7 hides blank lines on a sheet / page 8 a lot of dialog windows 9 Hide and show from 10th line 10 hide d1 if cell a1 is full show if empty 11 enter data into listbox and combobox 12 hide by address 13 identifying unique (single) data entries 14 row column hiding 2 15 show all row columns 16 show all hidden rows and columns 17 excel fonts 2 18 list formulas on new sheet / page 19 specifies in detail how many formulas are in the book (on new sheet / page) 20 Hides empty rows in column a