normal change row heights based on cell value

More
1 month 5 hours ago #2347 by Kuquery
Replied by Kuquery on topic change row heights based on cell value
I have further explored the issue I tried to explain in my previous post, as follows.
I have applied the VBA program to a range of consecutive whole numbers from 10 to 35.  The rows containing the numbers 10, 11, 12...15 returned my default row height: 11.25, but for the numbers 16,17..35 the program adjusted the row height to the respective number.  I then tried the numbers 35.5, 35.65 and 35.325 and the resulting row heights were as follows: 35.5, 35.75 and 35.5.  I suspect the "error" heights for 35.65 and 35.325 reflect the limits of sensitivity of the software.
Reverting to the issue of the smaller row heights; if I use Excel's manual row height adjustment function, the row heights adjust accordingly, within similar limits of sensitivity to those identified with 35.65 and 35.325. 
I suspect a parameter contained in my Excel 'Options' settings may be limiting the program's ability to adjust row heights less than 16.  Can anyone shed any light on this?
Chris 

Please Log in or Create an account to join the conversation.

More
1 month 3 days ago #2334 by Kuquery
I have used this VBA function, but I have found that each row height with a cell value less than 11.25 adjusts to that height.  I suspect that it isn't coincidental that this is the default in my version of Excel 2010 (operating on Windows 10).
Does anyone know how to resolve this.

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun