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

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

Two things

you don't need the brackets
thisapplication has to be defined

Try

Application.Names.Add "Hello", "=Sheet1!$a$1"

--
HTH

Bob Phillips

"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

Thanks for the reply Bob, that works fine.

My questiobn now though is in what context would the code I mentioned below
be correct (It must be correct in some context as it was cut and pasted from
MSDN).

Also how would I define "thisapplication" as you suggested below.

Again thanks for your help

Paul

"Bob Phillips" wrote in message
...
Two things

you don't need the brackets
thisapplication has to be defined

Try

Application.Names.Add "Hello", "=Sheet1!$a$1"

--
HTH

Bob Phillips

"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

like so

thisapplication = Excel.Application
Set myName = thisapplication.names.add("Hello","=Sheet1!$a$1")

--
HTH

Bob Phillips

"PC" <paulm dot c @ iol dot ie wrote in message
...
Thanks for the reply Bob, that works fine.

My questiobn now though is in what context would the code I mentioned
below
be correct (It must be correct in some context as it was cut and pasted
from
MSDN).

Also how would I define "thisapplication" as you suggested below.

Again thanks for your help

Paul

"Bob Phillips" wrote in message
...
Two things

you don't need the brackets
thisapplication has to be defined

Try

Application.Names.Add "Hello", "=Sheet1!$a$1"

--
HTH

Bob Phillips

"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