LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 271
Default vba autofilter problem

I have the below code:

With Sheets("Stores")

.Cells.AutoFilter Field:=1,
Criteria1:=Sheets("Worksheet").Range("C1").Value
.Cells.AutoFilter Field:=4,
Criteria1:=Sheets("Worksheet").Range("Q2").Value

End With

The first autofilter works fine.

The 2nd doesn't. Field 4 is a column (D) of dates. Worksheet.Range("Q2")
is a date. The cells are formatted the same. I can find a cell in column D
with the same value as worksheet.range("Q2") and use an If statement to
confirm the two values are equal. ???


--
Thanks
Shawn
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 problem Lawman Excel Discussion (Misc queries) 4 February 28th 08 04:48 PM
Problem with AutoFilter John Quinn Excel Programming 8 July 6th 07 02:04 AM
Problem using Autofilter [email protected] Excel Programming 1 May 22nd 07 12:15 AM
AutoFilter VBA Problem Michael Link Excel Discussion (Misc queries) 1 July 28th 06 04:41 PM
AutoFilter Problem longbow Excel Programming 3 November 24th 03 06:35 AM


All times are GMT +1. The time now is 08:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"