View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Simon Murphy[_4_] Simon Murphy[_4_] is offline
external usenet poster
 
Posts: 37
Default 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