Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
In VB, get Auto Filter Range
How can I in Excel VB get the Auto Filter Range from a sheet?
Next how can I can the Auto Filter Range of a specific column? Finally how can I set for filter range in VB then return the found items and values? Sorry so many questions but the boos wants something done yesterday. You know how that goes. (smile) Thanks in advance for any help? Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
In VB, get Auto Filter Range
Dim rng1 as range, rng as Range, rng2 as Range
set rng = ActiveSheet.Autofilter.Range set rng1 = rng.columns(3).Cells set rng2 = rng1.offset(1,0).Resize(rng1.rows.count-1).Specialcells(xlvisible) -- Regards, Tom Ogilvy "Michael Kintner" wrote in message ... How can I in Excel VB get the Auto Filter Range from a sheet? Next how can I can the Auto Filter Range of a specific column? Finally how can I set for filter range in VB then return the found items and values? Sorry so many questions but the boos wants something done yesterday. You know how that goes. (smile) Thanks in advance for any help? Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-filter includes too much range | Excel Discussion (Misc queries) | |||
Restricted Range in Auto filter | Excel Discussion (Misc queries) | |||
Auto Filter Range | Excel Worksheet Functions | |||
Separate Button for Auto Filter Selected Range | New Users to Excel | |||
Range limit for auto filter function | Excel Discussion (Misc queries) |