RobbieC
Active Member
- Joined
- Dec 14, 2016
- Messages
- 376
- Office Version
- 2010
- Platform
- Windows
Hi there, I have a bit of a dilemma with a worksheet... unfortunately, it involves merged cells... (argghhh... I know)
I have a merged range (AK17:BT17) which is formatted as text for user input... initially I had a problem with autofit on the height of this range, but I managed to get that solved with a bit of VBA...
However, the row height will only extend to a maximum of 410. Not a problem for most inputs, but I have had some users who have been putting FAR MORE info into this text input...
I have been thinking that I could create further series of merged cells below this offending row which could be used as an overflow. I know that there are things to consider such as character counting, carriage returns and number of lines in the text...
Is there a way to 'analyse' the inputted text and somehow spread any overflow over the subsequent rows...?
If you can point me in the right direction, I'd be most grateful
Thanks
I have a merged range (AK17:BT17) which is formatted as text for user input... initially I had a problem with autofit on the height of this range, but I managed to get that solved with a bit of VBA...
However, the row height will only extend to a maximum of 410. Not a problem for most inputs, but I have had some users who have been putting FAR MORE info into this text input...
I have been thinking that I could create further series of merged cells below this offending row which could be used as an overflow. I know that there are things to consider such as character counting, carriage returns and number of lines in the text...
Is there a way to 'analyse' the inputted text and somehow spread any overflow over the subsequent rows...?
If you can point me in the right direction, I'd be most grateful
Thanks
