Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting Long Text Lines in Footer | Excel Discussion (Misc queries) | |||
Problem After Inserting Cell Formula | Excel Discussion (Misc queries) | |||
Macro - Inserting text to a cell already containg text | Excel Worksheet Functions | |||
Macro - Inserting text to a cell already containg text | Excel Discussion (Misc queries) | |||
Long text gets cut off in the cell | Setting up and Configuration of Excel |