test = proper(sheets("sheet1").range("A1").value)
test = worksheetfunction.proper(sheets("sheet1").range("A 1").value)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"geebee" (noSPAMs) wrote in message
...
hi,

i have the following:

dim test as string
test = proper(sheets("sheet1").range("A1").value)

but this is not working... i am just trying to assign the Proper(A1) as a
string.

please help

thanks in advance,
geebee