View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton[_2_] Mike Middleton[_2_] is offline
external usenet poster
 
Posts: 110
Default Font by way of function?

Copacetic -

Is there a function that assigns the font for a given cell or range? <


No, I don't think so.

Or am I required to code it in VB? <


Yes, but a VBA User Defined Function used on a worksheet can only return a
value to a worksheet cell or cells. So, assigning a font would have to be
done with a subroutine.

- Mike
http://www.MikeMiddleton.com


"Copacetic" wrote in message
...
Hi guys...

Is there a function that assigns the font for a given cell or range? Or
am I required to code it in VB?