You could check here

http://www.nickhodge.co.uk/vba/codee...to_text_ file

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"rhw" wrote in message
...
How can I print an entire comment from an excel cell - if excel is cutting
off a large protion of the comment?