[dba-Tech] Excel - format a named range

Try using the macro recorder - do it manually, and nick the relevant bits of
the code from there for your macro.


Jon

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com]On Behalf Of jwcolby
Sent: Monday, July 09, 2007 4:26 PM
To: 'Discussion of Hardware and Software issues'
Subject: [dba-Tech] Excel - format a named range


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


The information in this e-mail is confidential and may also be legally
privileged. The contents are intended for recipient only and are subject
to the legal notice available on request from : webmaster at alcontrol.co.uk
ALcontrol Laboratories is a trading division of ALcontrol UK Limited.
Registered Office: Templeborough House, Mill Close, Rotherham, S60 1BZ.
Registered in England and Wales No 4057291