Cell Character Limitations In Excel 2000

[Jason M. Perretta MCSE CCNA MOS \(Outlook & Access]

I understand Microsoft Excel 2000 has a 35K character
limitation, but only 1K characters appear in a cell. Does
anyone know of a way to get around this limitation? VB
for Applications? If VBA is the way to go, can some share
the code? Thanks!

 

[Frank Kabel]

Hi
what you can do to extend the 1024 characters limit in a cell is
manually entering linebreaks with ALT+ENTER. No way arounf the 32K
limit

--
Regards
Frank Kabel
Frankfurt, Germany

"Jason M. Perretta MCSE CCNA MOS (Outlook & Access 2000) A+ Net+"

 

[Myrna Larson]

VBA may be even less helpful. There's limit as to the number of characters
that can be passed between a worksheet and VBA. In working out some recent
issues with the COMPARE.XLA utility, there were problems when a formula
exceeded (AIR) 903 characters.