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