View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 153
Default 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




.