Prev: Store formulas in Vlookups? (another try ;)
Next: What happened to setting up a constant using F4?
From: Copacetic on 17 Apr 2010 01:38
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?
From: Mike Middleton on 17 Apr 2010 02:15
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" <Copacetic(a)iseverythingalright.org> wrote in message
news:95iis5dctkr8q3o2kg9bhsr0dj23ftn7hj(a)4ax.com...
> 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?

From: ozgrid.com on 17 Apr 2010 04:20
VBA is your best bet. Simply record a macro.



--
Regards
Dave Hawley
www.ozgrid.com
"Copacetic" <Copacetic(a)iseverythingalright.org> wrote in message
news:95iis5dctkr8q3o2kg9bhsr0dj23ftn7hj(a)4ax.com...
> 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?

From: Steve Dunn on 19 Apr 2010 13:11
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" <Copacetic(a)iseverythingalright.org> wrote in message
news:95iis5dctkr8q3o2kg9bhsr0dj23ftn7hj(a)4ax.com...
> 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?

 | 
Pages: 1
Prev: Store formulas in Vlookups? (another try ;)
Next: What happened to setting up a constant using F4?