Hiding rows in Excel 2007 using macros
Closed
Younus Ali Engineer
-
Sep 20, 2009 at 11:06 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 20, 2009 at 08:43 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 20, 2009 at 08:43 PM
Related:
- Hiding rows in Excel 2007 using macros
- Save as pdf office 2007 - Download - Other
- Macros in excel download - Download - Spreadsheets
- Spell number in excel without macro - Guide
- How to take screenshot in excel - Guide
- Dd-mm-yyyy format in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 20, 2009 at 08:43 PM
Sep 20, 2009 at 08:43 PM
try these code statements
ActiveSheet.UsedRange.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Hidden = True
