Andy
Yep, that was it. I wonder how that got changed? I choose to believe that
it was a malicious virus instead of my own carelessness. Thanks.
Dick
"Andy Pope" wrote in message
...
Hi Dick,
Sounds like you have the 'Break on all Errors' option set.
Check your VBE options, Error trapping is on the General tab.
Try one of the other 2 options.
Dick Kusleika wrote:
I was pretty sure I knew how collections worked, but why do I get a run
time
error (457) with this macro? Doesn't the On Error Resume Next trap that
error? XL2000, Win98SE.
Sub test()
Dim theColl As New Collection
theColl.Add "me", "me"
On Error Resume Next
theColl.Add "me", "me"
On Error GoTo 0
End Sub
Thanks.
--
Cheers
Andy
http://www.andypope.info