Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
0x800a03ec - VB 2005 or VB 2008 & Excel 2007 (Range Text) (AddData
Copied from newsgroup posting I did last week:
__________________________________________________ ___ I've done more research and can pinpoint the exact place where the range fails. It is when I get to DD14 from my original post. That means 53 items in the range are ok and on the 54th it fails. In the real world this seems like a small number but has anybody ever had this limitation of either colun DB ok and DD bad or a 54th occurence of selecting items in a range to cause a failure???? THanks if anybody can help, Steve "Stephen Plotnick" wrote in message ... I hate to reply to my own message... but I went into Excel and copied the data from the debugger in VB and than selected all the cells one at a time and did the databar manually and it worked. ANy ideas if there is a limitation within VB 2005 and Edcel 2007 that could be causing this problem?? Any help would be great. Steve "Stephen Plotnick" wrote in message ... I'm getting HRESULT: 0x800A03EC On this statement: cfDataBar = osheet.Range(RangeText).FormatConditions.AddDataba r with these values in RangeText: B14,D14,F14,H14,J14,L14,N14,P14,R14,T14,V14,X14,Z1 4,AB14,AD14,AF14,AH14,AJ14,AL14,AN14,AP14,AR14,AT1 4,AV14,AX14,AZ14,BB14,BD14,BF14,BH14,BJ14,BL14,BN1 4,BP14,BR14,BT14,BV14,BX14,BZ14,CB14,CD14,CF14,CH1 4,CJ14,CL14,CN14,CP14,CR14,CT14,CV14,CX14,CZ14,DB1 4,DD14,DF14,DH14,DJ14,DL14,DN14,DP14 I use this code all the time without any problems but the number of items in RangeText builds dynamically and this one is quite larger than any other one I build. Thanks in advance, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I move documents between Excel 2007 and 2008 | Excel Discussion (Misc queries) | |||
How to connect the Excel 2007 in SQL Server 2005? | Excel Worksheet Functions | |||
how to save an Excel 2007 on CD, be able to open it using 2005 | Excel Discussion (Misc queries) | |||
Will Either Microsoft Office 2007 or 2008 Open an Excel 97 DocumentOK? | Excel Discussion (Misc queries) | |||
Chart.Export throws COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC. | Excel Programming |