change only specific fonts all sheets excel vba

[martindwilson]

i answered another q. here
http://www.excelforum.com/excel-work...excel-sss.html
but op wants to only change specified fonts on all worksheets to ariel and leave others intact, anyone help?

[BigBas]

I added a solution to the other thread. Any opinions?

[martindwilson]

thanks for the heads up i had another bash using some of your code and posted in same thread

[BigBas]

Martin,

Keep in mind that if you are using a select case with multiple possibilities, you dont have to list them each as a separate case.

For example, this would work:

Please Login or Register  to view this content.

[martindwilson]

much neater now if only i knew how to avoid loops in loops!