Hi Scott:

Worksheets(1).Cells("A1").AutoFormat(Format, Number, Font, Alignment, Border, Pattern, Width)

Basically, look up AutoFormat in VBA help :-)


>I'm using VFP 6 to create an excel form using automation.
>
>I can't find the !@#$$^&*( command to format the cells to currency, numeric, ... I'm sure it's in that excel VBA online help i've been staring blankly at, I can't find it.
>
>Anybody know off the top of their head??
>
>thanks in advance (tia)
>
>scott vandenelzen