ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Why cannot name a function A1 or NA77? (https://www.excelbanter.com/excel-programming/433602-why-cannot-name-function-a1-na77.html)

vsoler

Why cannot name a function A1 or NA77?
 
Why cannot name a function A1 or NA77?

Then a call to these functions is unable to find their definitions and
a #REF! is returned.

What's the problem?

Patrick Molloy[_2_]

Why cannot name a function A1 or NA77?
 
think about it.
= A1
returns what? the value in A1 or the value from your function? adding
ambiguity is definitley not a good thing. For the same reason you should
never use variable names that are the same as keywords in the language.

"vsoler" wrote:

Why cannot name a function A1 or NA77?

Then a call to these functions is unable to find their definitions and
a #REF! is returned.

What's the problem?



All times are GMT +1. The time now is 08:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com