Why can't i filter two different columns with different criterias like this

Posted to microsoft.public.excel.programming

Claus[_3_] Claus[_3_] is offline

external usenet poster

Posts: 40

Why can't i filter two different columns with different criterias like this

Hi
Range("E4:AI183").Select
Selection.AutoFilter Field:=1, Criteria1:=Leverandor,
VisibleDropDown:=False
Selection.AutoFilter Field:=35, Criteria1:="<",
VisibleDropDown:=False

It works without the third line.

I'm getting an error (1004) on the third line.

Regards,
Claus

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do sum a column only if meets the criterias of 2 columns	Lorenzo	Excel Discussion (Misc queries)	3	March 13th 08 04:34 PM
Filter data with two criterias	Geo	Excel Discussion (Misc queries)	5	October 1st 07 07:34 PM
Need function for one value for two criterias and two columns	Melanie	Excel Worksheet Functions	6	August 14th 06 05:38 AM
how to return the value of a cell based on two criterias in two columns	devdutt_dev[_2_]	Excel Programming	2	October 1st 04 03:33 AM
how to return the value of a cell based on two criterias in two columns	devdutt_dev	Excel Programming	2	October 1st 04 03:22 AM

All times are GMT +1. The time now is 11:08 PM.

Menu

About Us