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
|