StrConv is quite a bit faster. 8 times faster, according to my
calculations.


On Feb 21, 7:38*pm, "Rick Rothstein \(MVP - VB\)"
wrote:
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