DDE Command to Format Cell
Thanks, but, that didn't work either.
I have been able to change the font in the cell and the
command was
[SELECT("r10C5")][FONT.PROPERTIES(,"Bold")]
I would expect the cell formatting to use a NumberFormat
property of some object but I don't know this.
-----Original Message-----
How about [SELECT("R10C5")]
[Selection.NumberFormat "0.00"]
--
John
johnf202 at hotmail dot com
"Ron Louzon" wrote in
message
...
What is the DDE command to format an Excel cell? I want
to format a cell with NumberFormat="0.00". How do I do
this via DDE? I tried
[SELECT("R10C5")][Selection.NumberFormat("0.00")]
[SELECT("R10C5")][Cells.NumberFormat("0.00")]
[SELECT("R10C5")][Select.NumberFormat("0.00")]
but none of this works....obviously.
thanks,
Ron
.
|