Posted to microsoft.public.excel.programming

external usenet poster

Posts: 190

autofilter criteria

hi,

i have the following:

Selection.AutoFilter Field:=1,
Criteria1:=Sheets("lookup").Range("BM3").Value, _
Field:=3, Criteria2:=Sheets("lookup").Range("I3").Value

it seems to work when i just have the Criteria1, but when I add the
Criteria2, it shows no rows and doesnt work right.

What am i doing wrong?

thanks in advance,
geebee

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
AutoFilter Criteria in VBA	Abhi[_6_]	Excel Programming	5	April 25th 07 05:37 PM
autofilter criteria	Knox	Excel Programming	3	April 6th 07 01:21 PM
Selection.AutoFilter Field / Criteria = criteria sometimes non-existing on worksheet	markx	Excel Programming	1	November 24th 06 02:52 PM
Autofilter criteria not yet known	JeffMelton	Excel Programming	1	July 25th 06 08:12 AM
AutoFilter Criteria VBA	EstherJ	Excel Programming	2	August 20th 04 12:54 PM

All times are GMT +1. The time now is 03:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us