ExcelBanter - determine max characters in a range

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - determine max characters in a range (https://www.excelbanter.com/excel-programming/433538-determine-max-characters-range.html)

thomas donino

determine max characters in a range

I have a named range which is 10 columns wide. Is there any way to
determine, based on the font type and size what the maximum character length
is so I can test the string to be inserted into it to ensure it is not to
large?

All times are GMT +1. The time now is 10:21 PM.