That's good to hear, afraid my neural network is getting a bit tattered !

Regards,
Peter T

"Dave Peterson" wrote in message
...
And I meant my synapses! <vvbg

Dave Peterson wrote:

I'm just happy that some of the brain synapses are still firing. <bg

Jim Cone wrote:

Peter,
I just tried Dave's code using "AutoFilter.Range" in XL97
and it worked. I had assumed since it was not documented
that it would not work...not very smart. My apologies to Dave.
Regards,
Jim Cone

"Peter T" <peter_t@discussions
wrote in message
Hi Jim,
What am I missing, this works in xl97
Dim af As AutoFilter
ActiveCell.AutoFilter ' turn on
Set af = ActiveSheet.AutoFilter
Dave's code worked fine in my xl97
Regards,
Peter T

"Jim Cone"

wrote in message
XL 97 only has the AutoFilter Method...
XL2000 adds the AutoFilter Property which returns the AutoFilter
object.
--
Jim Cone