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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>
>>
>
>
Similar Threads
