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