get_Range Restrictions..
Edi
what about
get_Range("A1:A1000",missing);
and then pick out the ones you want in code
As well as the possible 255 char limit (may be 1024 - you need to check the
doco for your target Excel) there may be a possible issue with the 30
argument limit -but if you are upto 100 elements probably not in your case.
Could also be creating a range union with too many elements?
Hard to know without seeing more code
BTW
How do you find C# performance?
I've not been overly impressed so far
cheers
Simon
"Edi" wrote:
Hi,
Im using the get_Range function on the worksheet object
givning it two parameters : ex. get_Range("A1, A2,...Ln", Missing)
the problem is that when the number of elements in the string (sperated by
',')
is larger than 100~ im getting a com exception
any idea why is that?
thanks
|