| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Applying second filter and set print area
Hi all,
I have seven column(A:G) data starting from row2 as label and from row 3 onwards data, which would be filtered on column 7. I want to apply a second filter from this filtered data on column 2 and then set print area as the filtered range less one column (A:F) how can I do this with code? TIA Soniya |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Applying second filter and set print area
Application.AutoFilter.Range.Autofilter Field:=2, Criteria1:="ABCD"
Activesheet.PageSetup.PrintArea = Application.Autofilter.Range.Resize(,6).Address -- Regards, Tom Ogilvy "Soniya" wrote in message ... Hi all, I have seven column(A:G) data starting from row2 as label and from row 3 onwards data, which would be filtered on column 7. I want to apply a second filter from this filtered data on column 2 and then set print area as the filtered range less one column (A:F) how can I do this with code? TIA Soniya |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Applying function after filter is applied | Excel Worksheet Functions | |||
| Applying data as a line over an area chart | Charts and Charting in Excel | |||
| Need help applying a formula to a certain area of the worksheet | Excel Worksheet Functions | |||
| How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) | |||
| Filter two columns with criterion applying to one or the other? | Excel Discussion (Misc queries) | |||
Linear Mode
