This is part of code that I am trying to use, but fails at the last line ("AutoFill method of range class failed").
Code
Range("B2").Select
With ActiveCell
.FormulaR1C1 = "=PROPER(TRIM(RC[-1]))"
End With
Range("B2").AutoFill Destination:=Range("B2:B" & Range("B65536").End(xlUp).Row)
Is there something I am missing? (Obviously, but not sure).
Any help would be appreciated.