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

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

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

Thanks
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofilter for fixed columns 1
AutoFilter selected row not 'retained' across user unselect/select 3
Import multiple workbooks to current workbook in specified row number 0
How to set range to autofiltered visible cells? 7
Autofilter based on user inputbox 3
Utilizng full AutoFilter features while specific cells are protect 3
Autofilter Macro 5
Find Autofilter Header range 5

Back
Top