This is part of code that I am trying to use, but fails at the last line ("AutoFill method of range class failed").
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.