Use:

ActiveWorkbook.Names.Add "Hello", "=Sheet1!$A$2"

- Mangesh


"PC" <paulm dot c @ iol dot ie wrote in message
...
Hi,

I'm pretty new to excel vba. In an attempt to learn I'm playing around
with
code samples I've taken from MSDN just to see how they work and the
results
returned. The problem is when I use suggested code from the MSDN site I'm
receiving errors without explanation.

I'm try to get a grip on application methods and events etc. An example of
an error I'm getting is as follows:

Suggested code:

' create a new range in a worksheet
thisapplication.names.add("Hello","=Sheet1!$a$1")

so I place this in a sub as follows:

Sub Test()
thisapplication.names.add("Hello","=Sheet1!$a$1")
End Sub


When I run this I get an error "Compile Error: Expected: ="

What am I doing wrong here. This is very frustrating as this is just one
example of suggested code returning an error. Should I be approaching this
some other way.

Any suggestions appreciated.

Paul