View Single Post
 
Old 02-13-2021, 03:17 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,975
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

When a paragraph has more than one font size in it, the 'range' size font will return an undefined value which shows up as a blank font size in the GUI - but in VBA this will show as a number like 999999. There could be a large number of font sizes and typefaces in a single paragraph. You can augment the code to query every location inside a paragraph if an undefined value is encountered for the overall size or typeface but the value of that is dubious.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote