Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
xlConstants=2 xlTextValues=2 xlCalculationAutomatic=-4105 xlCalculationManual=-4135 oXL.Calculation = xlCalculationManual oXL.ScreenUpdating = @FALSE ForEach c In oWS.Cells.SpecialCells(xlConstants, xlTextValues) c.Value = oXL.WorksheetFunction.Proper(c.Value) Next oXL.Calculation = xlCalculationAutomatic oXL.ScreenUpdating = @True
Article ID: W16614
File Created: 2005:02:18:12:21:38
Last Updated: 2005:02:18:12:21:38