As always, post your code for comments.
http://tinyurl.com/hgzsf
--
Don Guillett
SalesAid Software

"Celt" wrote in message
...

I have a worksheet that has several macros and event macros in it. All
the macros work as I have used them several times before.

However, one of my endusers ran into an issue with one of my Event
Macro's... a worksheet change event. She had entered into a cell, a
large amount of text (without counting, I would say 200+ characters).
When she tries to enter more text, she gets a "Type Mismatch Error"
with the event macro.

I hope this is not a dumb question.....is there some sort of data limit
for a cell that is being violated to create this error?

Thanks for any help!!!


--
Celt
------------------------------------------------------------------------
Celt's Profile:
http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=550134