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