Hiding rows in Excel 2007 using macros

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
i need a macro which hides rows containing blank cells in a particular column

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
try these code statements

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

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month