PC Review


Reply
Thread Tools Rate Thread

Advance Filter data to store array

 
 
chandra sekaran
Guest
Posts: n/a
 
      27th Jul 2010
Hi All
I need code for array here is code

Column A
India
Rusia
UAE
USA
USA
Mexico

i have Advanced filter the column A Fillter data to Sheet2 Column A


Dim rOldList As Range
Set rOldList = Sheet1.Range("A1", Sheet1.Range("A65536").End(xlUp))

rOldList.AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=Sheet2.Cells(1, 1), Unique:=True


I need Sheet 2.Column A data Store to Array later on i can use
thi code to Criteria Range


Sheet5.Range("DATA").AdvancedFilter _
Action:=xlFilterCopy, _
CriteriaRange:="crnames", CopyToRange:=Range("DDRrange"),
Unique:=False


how can i store to Array in Filter Data after that i can use to
Criteria Range to same array.

Advanced Thaks,

Regards

Swathichandra , India, Chennai



 
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
Store data in array jfcby Microsoft Excel Programming 3 9th Apr 2009 01:27 AM
How Do You Take Data Off A Sheet and Store It In An Array =?Utf-8?B?UmFsZWlnaA==?= Microsoft Excel Programming 2 17th Jan 2006 08:47 PM
Pull data - Advance Filter =?Utf-8?B?bGlsJydiaWJiaWI=?= Microsoft Excel Worksheet Functions 1 29th Jun 2005 03:08 AM
Advance filter search does not filter an exact match cfiiland Microsoft Excel Programming 1 10th Jun 2005 12:44 PM
Copying filtered data using advance filter to another sheet bandula Microsoft Excel Misc 1 3rd Oct 2003 01:37 PM


Features
 

Advertising
 

Newsgroups
 


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