Bob, I apologize beforehand, in case you reply I will not see your
message until tomorrow, they are kicking me out of the building and I
gotta go. Have a good night.

Kostis


vezerid wrote:
Bob, you are intriguing me now <bg. Let us say I want to define a
named formula with relative references. As I understand it, the name is
simply a representative of a calculation routine, which in turn is
defined the formula. This formula, if unnamed, would cause the #REF!
error if copied out of bounds. Why should we not expect a similar
behavior by any formula using the named formula inside it?

Can you also explain the following?
The code should handle any
situation it considers an error, not have the system decide for it.

Are you referring to error handling at the VBA level of implementation?
To the formula? You mean a formula which will first test its relative
references' positions and decide to return an error value itself?


Bob Phillips wrote:
Hi Kostis,

I would say it is a feature on the following basis.

If you are using relative referencing presumably it is deliberate (this
thread is the exception to the rule <g), and as such, the last thing you
want is for it to error in any column/row. The code should handle any
situation it considers an error, not have the system decide for it. So a
feature IMO, but not one that I have ever utilised I must admit.

It also works on rows, 1 cycles around to 65536.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"vezerid" wrote in message
oups.com...
Glad it worked, thanks for the feedback.

I tried a similar test and I reproduced the behavior. I defined a name
test in B1 =A1. Then in A1 I entered =test and it was pointing to IV1.
Bug or feature, I wonder. Bob, since you are following the thread, any
ideas? Bug or feature?

Regards,
Kostis