Gustav Brock
Gustav at cactus.dk
Mon Jul 9 11:47:42 CDT 2007
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