Deleting all the hidden rows and columns in the active worksheet using VBA

Published on October 26, 2016 by abundantcode

Filed under Excel

Last modified October 26, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 1017 times

Do you want to delete all the hidden rows and columns in the active worksheet in Microsoft Excel using VBA ?. Here’s the code snippet that helps you to do it.

How to delete all the hidden rows and columns in Active Worksheet using VBA in Microsoft Excel ?

Sub DeleteHiddenSheets()
    For i = 256 To 1 Step -1
    If Columns(i).EntireColumn.Hidden = True Then Columns(i).EntireColumn.Delete Else
    Next
    For i = 65536 To 1 Step -1
    If Rows(i).EntireRow.Hidden = True Then Rows(i).EntireRow.Delete Else
    Next
End Sub
If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Comment


x

You might be Interested in these Posts

How to hide horizontal or vertical scroll bar using VBA Code in Excel ?

Here's a VBA code that hides the horizontal and vertical scroll bar in Microsoft Excel. How to hide...

Displaying all the worksheet names in Excel using VBA Code

Do you want to display the names of the worksheets in the excel workbook ?. Here;s how you can do it...

How to change positive numbers to negative in Microsoft Excel 2016 ?

Do you want to change the positive numbers to negative numbers and vice versa (or in simple terms) ,...