Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
applying column formatting programatically
I have:
ws.range("J").NumberFormat = "0%" and ws.range("K").NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)" where ws is dim'd as a worksheet This formatting code lines are copied from a VB6 program. However, I am coding in VB.net (VS2003) and they are giving me runtime errors: System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC. at Microsoft.VisualBasic.CompilerServices.LateBinding .LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack) Can anyone explain to me what's going on and show me the proper syntax for formatting the Excel worksheet objects in VB.net? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Applying Rule to Entire Column | Excel Discussion (Misc queries) | |||
Applying UDF In Conditional Formatting | Excel Discussion (Misc queries) | |||
Applying Formatting (Fonts) in Formuals | Excel Discussion (Misc queries) | |||
Copying Formats vs Formatting Programatically | Excel Programming | |||
applying standard formatting to a worksheet | Excel Programming |