'Excel VBA autofill with dynamic data

I'm trying to autofill data in an ongoing database. The problem is that the size of the data increases over time and my approach to use the autofill fucntion is static:

Range("O2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.AutoFill Destination:=Range("O2:O1895")

I need a solution to make this Range (O2:01985) dynamic, so the macro looks for the last cell with content and then autofills it to the end of the data.

Any ideas?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Excel VBA autofill with dynamic data

Sources

Related Questions