Syntax advice
? ["my_rng"]
my_rng
It just evaluates the string constant "my_rng" to a string - doesn't see it
as a range name.
--
Regards,
Tom Ogilvy
Alan Beban wrote in message
...
From the On-line help I would have expected ["my_rng"](5) to work, but
it doesn't either.
Alan Beban
Tom Ogilvy wrote:
Because Excel doesn't parse out []( ) as anything meaningful would be
my
guess.
Still, I don't know why you would use anything besides
Range("my_rng")(5)
--
Regards,
Tom Ogilvy
Terry von Gease wrote in message
...
Assume a named range "my_rng"
One can say: Range("my_rng")(5)
One can say : [my_rng].cells(5)
One can say: Evaluate("my_rng")(5)
But one cannot say: [my_rng](5)
Why is that?
--
Terry
"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley
|