Adding tick column next to active cells

I've managed to automate 90% of what I do to format a spreadsheet using Record Macro, except for adding a ✓ symbol next to a column of data.

When I record what I do, Excel doesn't notice I'm auto-filling down to the right of the last active cell. The macro only records autofilling the tick symbol starting from a specific start cell, down to an specific end cell. (ie. "H2:H230")

Example:

Formula:

Please Login or Register  to view this content.

Is there a way to tell Excel to autofill the ticks all the way down to the end of the data, until the data stops (wherever that may be)?

ie.

Word	✓
Word	✓
Word	✓
Word	✓

...etc

You can fill the cells without using autofill.

Please Login or Register  to view this content.