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 4186 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

Leave a Comment


x

You might be Interested in these Posts

C Program to find the G.C.D of a number using Recursive function

Problem Write a program in C to find the find the G.C.D of a number using recursion and display the ...

C Program to print a Half Pyramid using *

Problem Write a program in C to print Half pyramid using * as shown. * * * * * * * * * * ...

C Program to display Positive factors of a number

Problem Write a program in C to display all the positive factors of a number enter by the user. Ho...