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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.