[dba-Tech] Excel - format a named range

jwcolby jwcolby at colbyconsulting.com
Mon Jul 9 12:22:16 CDT 2007


Gotcha, thanks!

Don't ya think you'd be able to set all the format stuff via a format
method?  Bold, back color, fore color, font, numeric format etc?

That was what I was looking for.  And of course...


NOT! 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Monday, July 09, 2007 12:48 PM
To: dba-tech at databaseadvisors.com
Subject: Re: [dba-Tech] Excel - format a named range

Hi John

It's not a method but the property NumberFomat of your range you wish to set
to the format string of your choice.

/gustav

>>> jwcolby at colbyconsulting.com 09-07-2007 17:26 >>>
I need to format a named range to currency.  I have the range created but I
cannot find any method of the range object which will do a format on the
range.  

How is this done?

John W. Colby
Colby Consulting
www.ColbyConsulting.com 


_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com




More information about the dba-Tech mailing list