Resolved >>> FIltering Non blank Rows

**JOERIDEOUT** · 10-24-2007, 03:54 PM

Im new at this so if you can help please give step by step instuctions.
I have a very long excell sheet and I want to be able to have two buttons off to the side that allows me to filter and unfilter my page. What I want to accomplish is if the cell in column "A" is not populated then I do not want to see that entire row when I filter. any help would be greatly appreciated it would make me look like the office genius!!!!!!!!!
By the way I have never created a macro before and I believe that is what I need to do.

**VBA Noob** · 10-24-2007, 04:04 PM

Hi,

Maybe this link will help. Look at "Blank Cells in a Column"

http://www.contextures.com/xlautofil...html#FilterCol

If you need code then try

Columns(1).AutoFilter Field:=1, Criteria1:="<>"

Links should show you what to do

Where to place code

How to run code

Add buttons

or

Form Buttons

VBA Noob

**VBA Noob** · 10-24-2007, 04:44 PM

Attached is an example

VBA Noob

**JOERIDEOUT** · 10-25-2007, 10:02 AM

thanks for the sample it used your sheet as mine and it works fantastic. THANKS A MILLION!

**VBA Noob** · 10-25-2007, 10:03 AM

Glad it helped

Thx for the feedback

VBA Noob

**Tony Nilsson** · 10-19-2011, 05:43 AM

This will do what you want. Just edit the parameters with ?
/Tony

Sub Filter_On()
Dim rnCell, rnOmrade As Range

Set rnOmrade = Worksheets("Sheet?").Range(Cells(StartRow?, StartColumn?), Cells(LastRow?, LastColumn?).End(xlUp))

For Each rnCell In rnOmrade
If rnCell.Value = "" Then
rnCell.Rows("1:1").EntireRow.Hidden = True
End If
Next rnCell

End Sub