Nokia C3: AutoHide empty rows in excel? VBA Debug

AutoHide empty rows in excel? VBA Debug
Developing a spreadsheet to pull data from a base worksheet into 2nd and 3rd worksheets to generate reports. In the 2nd and 3rd worksheets I would like to use VBA code to autohide rows which are empty - data is not numerical but text.

I have input VBA found elsewhere on the internet (forgot the source but not mine) and tried my best to adapt it to my spreadsheet ..... it now works for the 2nd worksheet but not the 3rd (hides all rows on the 3rd). I am not a VBA guru and am having great difficulty debugging even this simple code.

The code runs when the worksheet is clicked. Any assistance is so very greatly appreciated!
Attached Files
File Type: zip VBA Help.zip (44.8 KB, 3 views)
Reply With Quote
#2
Old 28-10-2011
JyotiT JyotiT is offline
Member

Join Date: Aug 2011
Posts: 504
Re: AutoHide empty rows in excel? VBA Debug
Not much sure about the codes. But you can manage to see in the Advanced Filtering section for more information on this. This allows you some preset filter option by which you can configure autohide of rows. About the code you can try to web to look for more better examples. I had found many users discussing the same on other forums also.
Reply With Quote