This code worked when used in MS Word, now trying to run from excel. I want to format all the text in the document with the same font type and the same font size.
'Format document with universal font type and size
Selection.WholeStory
Selection.Font.Name = "Calibri"
Selection.Font.Size = 11
End With
This one also did not work:
ActiveDocument.Range.Font.Color = wdColorAutomatic
ActiveDocument.Range.Font.Name = "Calibri"
ActiveDocument.Range.Font.Size = 11
Best Answer
I guess this is in continuation to your last question. Try this. I have not deleted certain declarations from the previous code.