get_Range Restrictions..

[Guest]

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

 

[Tom Ogilvy]

Might have something to do with the length of the string/argument being
longer than 255 characters.

 

[Guest]

Being that get_Range is not a standard function in Excel VBA I can only give
you my best guess here. The string you are attempting to pass is in excess of
256 characters and that is causing a problem. You can try concatenating two
strings together instead of passing one long one.

 

[Guest]

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

 

[Guest]

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 I’m mixing both
Such that I’m 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, I’ve 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