Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding data within a range
hi,
hi i want to filter out a list od data to much a certain criteria, i currently use Selection.AutoFilter Field:=6, Criteria1:=exchange exchange is a variable, this works fine and it filters ok, but how cn i copy the filtered data and paste to another part of the sheet. once the data has been transferred somewhere else i display it in a userform. regards Johny5 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding data within a range
John
Hopefully this will help. It doesn't contain the code to filter, but you already have that, but it does define a range (myRng) and then after filtering, it uses the SpecialCells method to copy the visible cells only and move them to A1 on sheet2 Sub MoveVisibleCells() Dim myRng As Range Set myRng = Range("A2:G6") myRng.SpecialCells(xlCellTypeVisible).Copy _ Destination:=Worksheets("Sheet2").Range("A1") End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS wrote in message oups.com... hi, hi i want to filter out a list od data to much a certain criteria, i currently use Selection.AutoFilter Field:=6, Criteria1:=exchange exchange is a variable, this works fine and it filters ok, but how cn i copy the filtered data and paste to another part of the sheet. once the data has been transferred somewhere else i display it in a userform. regards Johny5 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Data in a range | Excel Discussion (Misc queries) | |||
finding a max date in a range in vlookup data | Excel Discussion (Misc queries) | |||
Finding a value associated with a range | Excel Worksheet Functions | |||
Finding min/max of adjacent data in a range of cells | Excel Worksheet Functions | |||
Finding data in a Range / Returning Cell Location | Excel Programming |