Formatting a cell for currency

[k483]

What's the VB code for formatting a cell to show currency (with dolla
sign and 2 decimals)? Worksheets("Sheet1").Cells(1,1).?????????=True

What's the syntax?
thank

 

[Frank Kabel]

Hi
one easy way: Set your format manually while recording a macro

 

[Guest]

Try something like

Worksheets("Sheet1").Cells(1, 1).NumberFormat = "$#,##0.00"

Regards,

Peo Sjoblom