Sam, sometimes when I don't get what I am looking for from the VBA or Excel
help files, I just go to Google and type in something like Proper Case VBA.
Here is one of the sites that came up for me.

http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx

A lot of times there is better information on the net than in the help files.

"Sam" wrote:

Hi,

Wow, thanks for the quick responses to my question yesterday. Now I have
a new problem. When I reinstalled Excel after my hard disk crash, something
went wrong with the Help files. When I press F1 for help, a white window
pops up, like it's supposed to, but then it freezes. Doesn't go any further.
When I close it, another window pops up saying, `Program is not responding
....'

Sometimes I can get to help by highlighting a word and pressing F1, but
then the font in the window is twice as big as it used to be, and the file
doesn't seem complete. This is true of both Excel Help file and VBA help
files.

Right now, I'm specifically trying to find proper syntax for the
capitalize function. I thought this would work:

Worksheets(1).Cells(2, 2) = vbProperCase(Worksheets(1).Cells(2, 2)

but it doesn't.

Any idea what's going on??

Sam