Hello - Is there a way to adjust the range for my Macro when I autofill a formula? For example I have a recorded macro for a trim function but obviously when I try and use the macro on a larger set of data the autofill range is only that of the original Macro recording. How can I adjust the range below to work with any amount of rows?
[ActiveCell.FormulaR1C1 = "=TRIM(RC[-1])"
Range("O2").Select
Selection.AutoFill Destination:=Range("O2:O20303")
Range("O2:O20303").Select
Columns("O:O").Select]
Bookmarks