HRESULT: 0x800A03EC

S

Stephen Plotnick

I'm getting HRESULT: 0x800A03EC

On this statement: cfDataBar =
osheet.Range(RangeText).FormatConditions.AddDatabar

with these values in RangeText:
B14,D14,F14,H14,J14,L14,N14,P14,R14,T14,V14,X14,Z14,AB14,AD14,AF14,AH14,AJ14,AL14,AN14,AP14,AR14,AT14,AV14,AX14,AZ14,BB14,BD14,BF14,BH14,BJ14,BL14,BN14,BP14,BR14,BT14,BV14,BX14,BZ14,CB14,CD14,CF14,CH14,CJ14,CL14,CN14,CP14,CR14,CT14,CV14,CX14,CZ14,DB14,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
 
S

Stephen Plotnick

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
 
S

Stephen Plotnick

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
 
Top