Formating Cells in VBA

[Greg Bloom]

How do I format a cell to be currency with VBA Code?

 

[Serge]

Goto Tools->macro->record macro
While macro is recording, select the cell, right click and select Format
Cells..., from Category listbox select Currency, OK. Click'Stop' button to
stop macro recording. Press Alt-F11, goto Modules and take a look at the
code for Macro1

 

[Tumbleweed]

Range("Sheet1!C7:C17).NumberFormat = "$#,##0.00"