Inserting Long Text in a Cell Problem
 

"Suh, Suk Ho" wrote in message
news:OkhGE4xYDHA.202@newsgroup...
Dear Colleagues;

Please forgive me if I'm posting this on a wrong newsgroup but I'm trying
to
extract data from Access into Excel.

When I get a data from a Memo field, whose string is very long(no problem
with short Memo field data), and insert it in a cell of a worksheet in
Excel, the cell displays #Value instead of its actual value.

I belive this is a limitation of a text in a cell of Excel. Is there a way
to go around this problem?

On 2nd thought,

I'm inserting a very long text from a TextBox control on a UserForm into a
cell without a problem.

Then it may not be with the cell length limitation.

Then I'm totally lost. Please Helpppp!

Suk Ho


Thank you

Suk Ho


There's a nice quicksort routine on Stephen Bullen's page

http://www.bmsltd.co.uk/Excel/SBXLPage.asp

Keith