Font by way of function?
 

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?

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?

Font by way of function?
 

VBA is your best bet. Simply record a macro.



--
Regards
Dave Hawley
www.ozgrid.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?

Font by way of function?
 

Hi,

look up Conditional Formatting in the help files. This may be what you are
after. Otherwise, give us more of an explanation for what you are trying to
achieve.




"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?