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


"Dave Peterson"

wrote in message
You sure a worksheet didn't have a .autofilter property in xl97? I don't
have
xl97, but I could have sworn it did. (I would have bet that xl95 didn't,
but
xl97 did.)
In any case, you could still use:
set rngF = .Range("_FilterDatabase")
And use the hidden name.


--

Dave Peterson

--

Dave Peterson