By Kuquery on Thursday, 09 July 2020
Posted in Kutools for Excel
Replies 1
Likes 0
Views 5.6K
Votes 0
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.
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 
·
3 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post