Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting "file corrupted" messages, started recently. | Excel Discussion (Misc queries) | |||
cancel the "Getting Started" Dialogue Box when I open XL/Word | Setting up and Configuration of Excel | |||
How to AutoFilter certain cells in a column (in Excel not VBA) for an Asterisk "*" ? | Excel Discussion (Misc queries) | |||
How to permanently get rid of "Getting Started" task pane in Exce | Excel Discussion (Misc queries) | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |