Thread: Syntax advice
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Terry von Gease Terry von Gease is offline
external usenet poster
 
Posts: 38
Default Syntax advice

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