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