application.Value(Variable)

D

David

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
 
T

Tom Ogilvy

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)
 
D

David

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




.
Click to expand...
 
T

Tom Ogilvy

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.
 
Top