User login
Recent blog posts
- How to enable grouping in protected sheet
- How to do vlookup Using VBA?
- VBA function?
- Finding the Last row on Excel sheet with VBA Macro
- How to find last row in an Excel sheet with Macro VBA
- Loan Calculator excel sheet-calculate payments for upto 360 months
- Learn How to use VBA uBound in Excel
- Code to List All Named Ranges in a Worksheet
- amortization formula excel
- excel amortization table
Reset Auto Filter and unhide Rows and Columns using Excel VBA
Autofilters and hidden cells are a nemesis when you perform some operations. The following simple macro will unhide all rows/columns and turn-off the autofilter
Sub RemoveFiltersAndHiddenRows()
Dim oWS As Worksheet
For Each oWS In ActiveWorkbook.Sheets
oWS.AutoFilterMode = False
oWS.UsedRange.Rows.Hidden = False
oWS.UsedRange.Columns.Hidden = False Next
End Sub
Delicious
Digg
StumbleUpon
Propeller
Reddit
Furl
FacebookCode/Templates/Informaiton provided on this site are without any liabilities. Owner of this website in no event will be held reponsible to damages resulting by using the code/templates/applications/
Copyright © 2003 xlMacros.com - Learn Excel VBA
Microsoft Excel is a U.S. registered trademark of Microsoft Corporation
Excel Password Cracker Addin.
For $10 Today. Price back to $20 tommorow.
Never Worry About Lost Excel Passwords!!!
Remove Excel Password - the easy way has never been easier than this.
New Posts
- 1 of 11
- ››
Syndicate
