Named range, maximum characters in RefersTo property
 

Hi there,

I need to create a named range that refers to multiple cells, but it seems
that the maximum number of characters that I can use programmatically is 100
characters. But if I create the named range in Excel using the same amount
of cells its fine.
I am creating the named range using an addin written in Delphi.

Jason

Named range, maximum characters in RefersTo property
 

this also happens using VBA

"Jason Coley" wrote in message
...
Hi there,

I need to create a named range that refers to multiple cells, but it seems
that the maximum number of characters that I can use programmatically is
100 characters. But if I create the named range in Excel using the same
amount of cells its fine.
I am creating the named range using an addin written in Delphi.

Jason