application.Value(Variable)
 

Hi Group,

Brought in a text value via InputBox, "NoWks", which I am
trying to make into a value. Done this before, but am
using 2003, maybe something has changed?

Immediate window:
?application.value(NoWks)
Get message "wrong number of arguments"

Thanks

application.Value(Variable)
 

As far as I know there is no Application.Value. What do you expect to get
from

application.Value(NoWks)

is NoWks a variable that holds a value?

NoWks = InputBox("Please enter a number")

if so,

? cdbl(NoWks)

or
? clng(NoWks)

--
Regards,
Tom Ogilvy

"David" wrote in message
...
Hi Group,

Brought in a text value via InputBox, "NoWks", which I am
trying to make into a value. Done this before, but am
using 2003, maybe something has changed?

Immediate window:
?application.value(NoWks)
Get message "wrong number of arguments"

Thanks

application.Value(Variable)
 

i am trying to turn the text into a value, number.
-----Original Message-----
As far as I know there is no Application.Value. What do
you expect to get
from

application.Value(NoWks)

is NoWks a variable that holds a value?

NoWks = InputBox("Please enter a number")

if so,

? cdbl(NoWks)

or
? clng(NoWks)

--
Regards,
Tom Ogilvy

"David" wrote in
message
...
Hi Group,

Brought in a text value via InputBox, "NoWks", which I
am
trying to make into a value. Done this before, but am
using 2003, maybe something has changed?

Immediate window:
?application.value(NoWks)
Get message "wrong number of arguments"

Thanks




.

application.Value(Variable)
 

Maybe you are thinking of
Application.WorksheetFunction.Value

Marcotte

application.Value(Variable)
 

if he was, it makes no difference. Neither

application.Worksheetfunction.Value or
application.Value are valid

This is one worksheet function that isn't supported in VBA.

--
Regards,
Tom Ogilvy



"Marcotte A" wrote in message
...
Maybe you are thinking of
Application.WorksheetFunction.Value

Marcotte

application.Value(Variable)
 

So I gave you a way to do it.

--
Regards,
Tom Ogilvy

"David" wrote in message
...
i am trying to turn the text into a value, number.
-----Original Message-----
As far as I know there is no Application.Value. What do
you expect to get
from

application.Value(NoWks)

is NoWks a variable that holds a value?

NoWks = InputBox("Please enter a number")

if so,

? cdbl(NoWks)

or
? clng(NoWks)

--
Regards,
Tom Ogilvy

"David" wrote in
message
...
Hi Group,

Brought in a text value via InputBox, "NoWks", which I
am
trying to make into a value. Done this before, but am
using 2003, maybe something has changed?

Immediate window:
?application.value(NoWks)
Get message "wrong number of arguments"

Thanks




.