Hide blank rows button macro

[cabinetguy]

I am trying to figure out how to make a button macro that will scan column A and if the value is blank or has the word "qnt." in it, then it will hide that entire row and also another button macro to unhide those same rows if I need to expand everything again.

[venkat1926]

assign these two macros for the two buttons

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[cabinetguy]

Works great, thank you. The unhide formula had the wrong column, but I fixed it and it works great, thank you.

[cheggers33]

Appreciate this is an old thread, but its NEARLY what I'm after and I am a total novice at this stuff - so didn't feel a total new thread would be useful.

Sub hide_rows()
Dim r As Range
Dim r1 As Range
Set r = Range("A1").CurrentRegion
r.AutoFilter Field:=1, Criteria1:="=", Operator:=xlOr, Criteria2:="qnt"
Set r1 = r.Cells.SpecialCells(xlCellTypeVisible)
Set r1 = r.Offset(1, 0).Resize(Rows.Count - 1, Columns.Count).Cells.SpecialCells(xlCellTypeVisible)
ActiveSheet.AutoFilterMode = False
r1.Rows.Hidden = True
End Sub

The above code nearly works in that I want it to delete empty rows on a different sheet (named 'Quote') to the button is, but I can't seem to work out where to enter this information.

Help much appreciated!

J

[FDibbins]

cheggers33 welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

(also, please take a look at the rules regarding using code tags when posting VBA code )

[cheggers33]

cheggers33 welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

(also, please take a look at the rules regarding using code tags when posting VBA code )

Apologies! Will repost. Thanks