Thread: Change Case for Names
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default Change Case for Names
A little more detail:

Sub Conv()
For Each cell In Selection
cell.Value = StrConv(cell, 3)

I always find using the built-in VB constants makes reading a statement
easier...

cell.Value = StrConv(cell, vbProperCase)

Rick


Next cell
End Sub

Reply With QuoteReply With Quote