I'm getting HRESULT: 0x800A03EC
On this statement: cfDataBar =
osheet.Range(Ra ngeText).Format Conditions.AddD atabar
with these values in RangeText:
B14,D14,F14,H14 ,J14,L14,N14,P1 4,R14,T14,V14,X 14,Z14,AB14,AD1 4,AF14,AH14,AJ1 4,AL14,AN14,AP1 4,AR14,AT14,AV1 4,AX14,AZ14,BB1 4,BD14,BF14,BH1 4,BJ14,BL14,BN1 4,BP14,BR14,BT1 4,BV14,BX14,BZ1 4,CB14,CD14,CF1 4,CH14,CJ14,CL1 4,CN14,CP14,CR1 4,CT14,CV14,CX1 4,CZ14,DB14,DD1 4,DF14,DH14,DJ1 4,DL14,DN14,DP1 4
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
On this statement: cfDataBar =
osheet.Range(Ra ngeText).Format Conditions.AddD atabar
with these values in RangeText:
B14,D14,F14,H14 ,J14,L14,N14,P1 4,R14,T14,V14,X 14,Z14,AB14,AD1 4,AF14,AH14,AJ1 4,AL14,AN14,AP1 4,AR14,AT14,AV1 4,AX14,AZ14,BB1 4,BD14,BF14,BH1 4,BJ14,BL14,BN1 4,BP14,BR14,BT1 4,BV14,BX14,BZ1 4,CB14,CD14,CF1 4,CH14,CJ14,CL1 4,CN14,CP14,CR1 4,CT14,CV14,CX1 4,CZ14,DB14,DD1 4,DF14,DH14,DJ1 4,DL14,DN14,DP1 4
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