Specifically (to match Mike's example)...

Range("A1").Value = StrConv(Range("A1").Value, vbProperCase)

where the predefined vbProperCase constant tells it to perform the proper
case conversion.

Rick


"Dave Peterson" wrote in message
...
Or StrConv.


Mike, H wrote:

Try this,

Range("A1").Value=Application.WorksheetFunction.Pr oper(Range("A1").Value)

Mike

On Mon, 6 Dec 2004 09:01:08 -0800, "!!!"
wrote:

What is the vba equivalent to the worksheet proper
function?

--

Dave Peterson