PC Review


Reply
Thread Tools Rate Thread

autofilter values

 
 
dede
Guest
Posts: n/a
 
      22nd Dec 2009
Hi
after an autofilter,
(Selection.AutoFilter field:= 3, Criteria1:="=X")

I will retrieve all "X" under the 1cEcto (sheet looks like below !!)
(A) (B) (c)
1) B1=SUBTOTAL(3;A:A)
2)AHC Batch 1cEcto
3)001 05
4)002 06 X
5)003 01
6)004 01 X

How could I find all (A) related
nb_bout_IDBS_trouvées = Worksheets("IDBS").Range("B1").Value
For recherche_bout = 1 To nb_bout_IDBS_trouvées

AHC_IDBS = Worksheets("IDBS").Cells(recherche_bout + 1, 1).Value
===> this last line does not work because I will retrie AHC_IDBS = 001 and
need to be 002 // next one will be 004
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
autofilter average values my.wandering.mind@gmail.com Microsoft Excel Programming 2 28th Mar 2008 12:38 PM
Displaying only specified values-not using Autofilter David Holman Microsoft Excel Discussion 8 24th Nov 2006 08:43 AM
AutoFilter list of values =?Utf-8?B?Ui5KLkgu?= Microsoft Excel Misc 2 19th Apr 2005 04:49 PM
how to autofilter for the remaining values???? monica Microsoft Excel Programming 1 9th Sep 2004 12:22 PM
AutoFilter Values + DropDown Boxes VBA chrisdarl Microsoft Excel Programming 0 26th Apr 2004 10:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:47 AM.