I am trying to use AutoFormat in VBScript through SQL Server in a DTS
package. Most everything is going great but I can't figure out the
syntax for this line:

oSSBExcel.Range("A65536").End(xlup).AutoFormat Format:=11

This is supposed to grab the last used row and apply an autoformat. It
works great when run in Excel, but I think it chokes on Format:=11.

Is there a way to say this in VBScript?

Thanks much.

Weezy


--
Weezy1957
------------------------------------------------------------------------
Weezy1957's Profile: http://www.excelforum.com/member.php...o&userid=24498
View this thread: http://www.excelforum.com/showthread...hreadid=380924