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