I want to set the row height on the basis of the character count in one cell.
The worksheet uses one very important cell that is merged (so the row height does not adjust automatically) and this is the cell I need to set the row height to accommodate.
I can get the number of characters using "LEN".
The row height can be specified by "Selection.RowHeight ="
Then it seems like some "IF" statements or "CASE" manipulations
So, if the character count is between 0 and 50, make the row height 20,
if it is between 50 and 100, make the row height 40 etc. I can determine acceptable parameters by trial and error.
I am envisioning that this would be activated by a form button for the time being.
Once I can do it for one row I'll figure out how to make it progress through the 35 rows of the worksheet as part of another VBA routine.
Help is always appreciated!
The worksheet uses one very important cell that is merged (so the row height does not adjust automatically) and this is the cell I need to set the row height to accommodate.
I can get the number of characters using "LEN".
The row height can be specified by "Selection.RowHeight ="
Then it seems like some "IF" statements or "CASE" manipulations
So, if the character count is between 0 and 50, make the row height 20,
if it is between 50 and 100, make the row height 40 etc. I can determine acceptable parameters by trial and error.
I am envisioning that this would be activated by a form button for the time being.
Once I can do it for one row I'll figure out how to make it progress through the 35 rows of the worksheet as part of another VBA routine.
Help is always appreciated!
