What name range cannot be used on VBA?

[alee001]

I was define some name range on cell or area on worksheet, but they cannot be used on code as like:

Range("Time") on cell; [Time] on code
Range("Type") on cell; [Type] on code
Range("Name") on cell; [Name] on code

I found that if auto form uppercase on name which cannot be used on code. Are there other word restrictions that cannot be used? Thanks

 

[mikerickson]

Generally, its best to avoid using names that are either keywords or cell addresses or the names of functions.

I think that your problem might also be with the bracket (evaluation) notation.
Range("Time") looks for a range named time.
[time] tries to evaluate the string "=time" which Excel can't decide if its a name or a malformed formula.

 

[alee001]

Generally, its best to avoid using names that are either keywords or cell addresses or the names of functions.

I think that your problem might also be with the bracket (evaluation) notation.
Range("Time") looks for a range named time.
[time] tries to evaluate the string "=time" which Excel can't decide if its a name or a malformed formula.

Thanks, Is there a list of names that I can't use to get my attention?