Log In
Register
Home
New Member
September 29, 2024
Offline
Dynamic Arrays have changed my life, and I can now use them instead of VBA to write reasonably formatted reports.
Where a Report includes variable length text I use AutoFit Row Height. But when a cell's value is changed by a formula - rather than by a user - it does not work. Some Report cells may be truncated without the user realizing (especially if it is saved as .pdf). See sanitized attachment. The workbooks are widely distributed to users with varying levels of Excel expertise - they expect Excel to "just work".
I could solve it with a simple VBA line; but as my organization is migrating from 2013 to 365 it is also blocking VBA for most users. Is there a non-VBA solution (apart from littering the workbook with hi-vis warnings and instructions)?
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Perhaps not the answer you want, but is it possible adjusting the height and width beforhand? In that way the expected data is shown as expected.
I have noticed the same behaviour and have not seen any other solution than to make sure the cell is big enough to show the data or to manually adjust afterwards.
Br,
Anders
1 Guest(s)
