Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Question
Hi all, i have used the code below to insert a filter in a specific
cell, but it puts the filters in row 2 all used cells ? Am i doing something wrong ? Range("E18").AutoFilter Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Question
It makes no sense to autofilter a single cell. So, just like when you do an
autofilter manually, Excel guesses what the range should be. If you specific a multi-cell range however Excel will use it. -- Jim "Les Stout" wrote in message ... | Hi all, i have used the code below to insert a filter in a specific | cell, but it puts the filters in row 2 all used cells ? Am i doing | something wrong ? | | Range("E18").AutoFilter | | | Best regards, | | Les Stout | | *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Question
Thanks very much Jim.
-- Les "Jim Rech" wrote: It makes no sense to autofilter a single cell. So, just like when you do an autofilter manually, Excel guesses what the range should be. If you specific a multi-cell range however Excel will use it. -- Jim "Les Stout" wrote in message ... | Hi all, i have used the code below to insert a filter in a specific | cell, but it puts the filters in row 2 all used cells ? Am i doing | something wrong ? | | Range("E18").AutoFilter | | | Best regards, | | Les Stout | | *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter Question | Excel Programming | |||
another autofilter question | Excel Programming | |||
AutoFilter Question | Excel Discussion (Misc queries) | |||
autofilter question | Excel Programming | |||
Autofilter Question | Excel Programming |