Code to Hide and Unhide Rows

**jcoulter** · 01-12-2012, 05:29 PM

Wonder if anyone can help speed up the code I've written below. I'm not a VBA guru so I'm sure there is something I'm missing.

I have a worksheet with a range of rows I want to hide based on the contents of column A. If column A is "", I want to hide the row. Otherwise the row is to remain visible. There is no data entry in the sheet, everything is being pulled from other worksheets or workbooks. Once all the other sheets and books have been updated, I have the user press <Shift><Ctrl><A> to run this code.

This code works fine, just VERY slow. Takes about 10 seconds on my dinosaur. Any help speeding this up would be appreciated.

JC

Please Login or Register  to view this content.

**tom1977** · 01-12-2012, 05:45 PM

I am not sure that speed up much yuor code buy try this

Please Login or Register  to view this content.

In my opinion the problem is not in the code (this kind of code sholud not run 10sec)

**jcoulter** · 01-13-2012, 10:25 AM

Thanks Tom ... you were right, didn't really speed things up but I think it cleaned up my code some. It did get me to thinking about why it was taking so long to run the macro. My sheet has a LOT of calculations and lookups. I turned auto calc off at the beginning of the code and then back on. Solved the problem.