Hi Jim...........thanks for the thought, but my IE is still 6.0 on this
machine, so that wasn't it. For the record tho, I was able to successfully
run the process on XL2000 (which machine also got the upgrade).......also
noticed that the process worked fine in 97 if I deleted the CommentBoxes out
of one of the columns......but 2000 and 2002 work fine with them in place.

Vaya con Dios,
Chuck, CABGx3



"Jim Cone" wrote:

Hi Chuck,
I saw a post ( I know not where) in the last day or so that blamed
an XL97 crash on the installation of IE7. Perchance is that
what the upgrade was on your system?
Regards,
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html



"CLR"
wrote in message
Hi All.........
I wrote a program a couple of years ago that has worked fine ever since,
till today. Today MIS blessed all of us with an unannounced "Windows
Upgrade", (WinXP) that took over our computers and demanded a re-boot or
would not function any further until we did. Once taking the "upgrade", it
took 2-3 re-boots to get back to normal. Then, when re-opening the Excel
Program, the AutoFilter function started acting up. The database is 16000
rows and about 25 columns. The procedure is.....First filter on a dropdown
from the column C arrow, then on one from the column G arrow, and then
delete one row.....then try to filter on a different selection from column G
and Excel freezes up. Does not work from there on. Before today, this
procedure worked fine. Doing Ctrl-Alt-Delete and trying to "EndTask", shows
two instances of Excel in the window......non-responding, even tho we only
had one running. This all in XL97, the same on two different
computers.......when I tired the same thing with the same file in XL2002
from the same network directory, all worked fine. The problem appears to
have affected XL97 but not XL2002, and apparently was not related to the
file as such......have not tired with XL2000 yet.

Anybody run across anything like this yet? If so, any fixes...........

Vaya con Dios,
Chuck, CABGx3