Macro for filter

[Amey]

Dear sir ,

I have just started learning macros.I want to creat a macro for "
Late " activities in the "Status " column. When I complete the procedure and
go to VBE , there the steps end at Autofilter.It just creats filter but next
procedure it doesn't take.Even if when I write
Autofilter
Selecttaskcolumn column:="status"
FilterApplyName= "Late"

Even then it just inserts filter but doesn't filter " Late" in "status"
column.It doesnt show any debug message also. So what I need to do for it.

 

[Rod Gill]

Hi,

Try recording a macro of you manually doing what you want. The recorded code
may provide everything you need or at least a great start. Record thru
Tools, macro, record new macro exactly the same as in Excel.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Dear sir ,

I have just started learning macros.I want to creat a macro for "
Late " activities in the "Status " column. When I complete the procedure
and
go to VBE , there the steps end at Autofilter.It just creats filter but
next
procedure it doesn't take.Even if when I write
Autofilter
Selecttaskcolumn column:="status"
FilterApplyName= "Late"

Even then it just inserts filter but doesn't filter " Late" in "status"
column.It doesnt show any debug message also. So what I need to do for it.
--
Amey B. Vidvans,
Planning Engineer
(e-mail address removed)

__________ Information from ESET Smart Security, version of virus
signature database 4808 (20100126) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4808 (20100126) __________

The message was checked by ESET Smart Security.

http://www.eset.com