| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtered Data
How can I programatically identify the range of rows displayed by filtered
data? I programatically provide the filter value, and then need to copy the results to another sheet. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filtered Data
Marvin, Use this code change Column "A" for your filtered column.
Range("A2",Range("A2").End(xlDown)).EntireRow.Spec ialCells(xlCellTypeVisible).Copy Worksheets("YourSheet2").Range("A1") -- Charles Chickering "A good example is twice the value of good advice." "Marvin" wrote: How can I programatically identify the range of rows displayed by filtered data? I programatically provide the filter value, and then need to copy the results to another sheet. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return filtered values into report worksheet based on filtered valueon the data worksheet | Excel Worksheet Functions | |||
| MS2007 - deleting filtered data, deletes non-visible data too | Excel Discussion (Misc queries) | |||
| Sum of filtered data | Excel Worksheet Functions | |||
| Filter data and fill only filtered data | Excel Discussion (Misc queries) | |||
| Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
Linear Mode
