Hiding rows in Excel 2007 using macros

Closed
Younus Ali Engineer - Sep 20, 2009 at 11:06 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 20, 2009 at 08:43 PM
Hello,
i need a macro which hides rows containing blank cells in a particular column
Related:

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Sep 20, 2009 at 08:43 PM
try these code statements

ActiveSheet.UsedRange.SpecialCells(xlCellTypeBlanks).Select
    Selection.EntireRow.Hidden = True
2