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 ***

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 ***

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 ***