Is there any way to set the autofilter of a specified column to "non blank" when the workbook is started?
 

Is there any way to set the autofilter of a specified column to "non
blank" when the workbook is started?

Thanks

Is there any way to set the autofilter of a specified column to "non blank" when the workbook is started?
 

Daniel,

Add this sort of code to the Thisworkbook code module

Private Sub Workbook_Open()

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

End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Daniel" wrote in message
om...
Is there any way to set the autofilter of a specified column to "non
blank" when the workbook is started?

Thanks