Thanks for your suggestions, Darren. I have tried them all to no avail :(
-----Original Message-----
From: ProfoxTech [mailto:[email protected]] On Behalf Of Darren
Sent: 13 September 2013 13:39
To: [email protected]
Subject: RE: Strange Excel behaviour
Paul a few things I found dealing with excel.
1. No need for CHR(13)
2. Use autofit ...
Set loRange to the entire sheet
loRange.COLUMNS.autofit
loRange.ROWS.autofit
-----Original Message-----
From: ProfoxTech [mailto:[email protected]] On Behalf Of Paul Newton
Sent: Friday, 13 September 2013 10:25 PM
To: [email protected]
Subject: Strange Excel behaviour
Hi all
I am using automation to populate cells in Excel. Some of the text in the
cells consists of two lines, e.g. "Fred" + CHR(10) + CHR(13) + "Flintstone".
When I open the spreadsheet it appears in the cell as "FredFlintstone" but it
shows as two lines in the formula bar. If I click in the formula bar and then
click anywhere in the spreadsheet it appears in the cell correctly.
Any ideas how to get around this?
Many thanks
Paul Newton
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
