Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Accesses the PROPER( ) function through the Application WorksheetFunction object

Sub FixText()         ActiveCell.Value = Application.WorksheetFunction.Proper("asdf")      End Sub