Thanks for all your answers

I guess the problem might be in the number of characters as you
All suggested I had found that I can put no more than 200~ characters
Into my get range function ... the problem is that this function is much
faster than
Excel.Application.Union (range1, range2) so Im mixing both
Such that Im assigning 200 chars for the get_Range function and union it
with another 200
Characters..

Well I guess I will have to live with it :)

BTW Simon, Ive not been impressed at all
With the performance in c# after more than a year working with it.
Hope that vesto2 will improve it

Edi


"Simon Murphy" wrote:

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