Hi, I am using VBA to query a database and then putting data into cells.
Some values have really long text in them and excel automatically turning on
wordwrap for some of them which results is very large cells in some places
which throws off the view of the worksheet. Is there any way to prevent
excel from doing this. i dont mind not being able to see all of the text.
Also, is there anyway to prevent excel from spilling long text into the next
column if the next column is blank? Thanks

Mark