View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
malik641[_7_] malik641[_7_] is offline
external usenet poster
 
Posts: 1
Default Search Text in Comments


Hey thanks a lot Dave, that message box really helped. I had an error o
a specific cell, but the cell had a normal comment in it. Here's what i
had:

1 V. Term:
J. Hoek

1 Transfer Out:
B. Colfer

When I deleted this comment the macro ran just fine. I have NO clu
what was wrong with this comment....

Any ideas on why what happened?

Otherwise thanks again Dave, I really appreciate it.

....That's also a pretty useful way of debugging..

--
malik64
-----------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...fo&userid=2419
View this thread: http://www.excelforum.com/showthread.php?threadid=38619