Sleeper: Printing entire contents of a cell

[gibbo1715]

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]

This is in the kb, have a look here

[gibbo1715]

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