Font Listing

[Mrs. T]

Hi,

Is there any way that I can download a listing of all the fonts that I have and in each cell they change to that font?

For example:
CELL A1 - would say Arial - in the that font
CELL A2 - would say Arial Narrow - in that font

 

[James006]

Hello,

A UDF ...is a User Defined Function ...

You only need to store in a standard module ...

And, then in your worksheet ... use as a regular function ...

=[COLOR=#333333]GetFontName(A1)[/COLOR]

Hope this will help