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

--
Regards,
Tom Ogilvy

"Edi" wrote in message
...
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