PDA

View Full Version : Sleeper: Printing entire contents of a cell



gibbo1715
08-27-2005, 01:05 AM
can anyone help with this, i have a spreadsheet where some of the cells in one column exceed the maximum print limit set on excel

can anyone tell me if there is a way to get excel to print the entire contents of the cell if it exceeds the 1024 chars limit

cheers

gibbo

johnske
08-27-2005, 01:24 AM
This is in the kb, have a look here (http://www.vbaexpress.com/kb/getarticle.php?kb_id=421)

gibbo1715
08-27-2005, 01:45 AM
thanks, sorry hadnt spotted that one, i can see the principle but how do i now get it to auto size the cell to fit the content before it prints?

when i try it still cuts the bottom off even when the content is less than 400 rows high?

I can use vbA to set the height to 405 for the cells i know may get that big which will work for me on my current project so this has solved my problem but curious for the future

Thanks

Gibbo