View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jose[_3_] Jose[_3_] is offline
external usenet poster
 
Posts: 1
Default Cell comment string trunckating

Hi,

Has anybody been able to read a comment of 600+
characters. I have not found any documentations saying
that this is not possible, but my strings trunckate at
random lengths.

Dim txt as string
txt = String(600," ")
txt = cells(1,1).comment.text()

The comment in cell(1,1) is very long, but it trunckates.
I am using Excel 2002 SP3. Anyone familiar with this
problem.

Thanks for the help.

Jose