filter non-blanks before closing
 

hello!

could anyone help me with my problem?
the case is, I want to auto filter the non-blanks of a column (i.e. "A3")
and save it before I close the file....

thanks in advance for your assistance.

filter non-blanks before closing
 

I'd start by recording a macro (show all data first????) when I did it manually.

But instead of running the macro before the workbook closes, I'd put it in the
Auto_Open procedure.

Then instead of having to figure out what to do (what happens if the user
doesn't want to save the changes???), the workbook will open nicely.

Record that macro and rename the macro to Auto_open

Then save, close and reopen to test.

Kevin_apprentice wrote:

hello!

could anyone help me with my problem?
the case is, I want to auto filter the non-blanks of a column (i.e. "A3")
and save it before I close the file....

thanks in advance for your assistance.

--

Dave Peterson