I need to copy data from one cell into a number of rows but the number of rows will change each time the report is produced. The macro I have created so far includes the following which I assume is the part that is copying the data into the cells:

Range("D1").Select
Selection.AutoFill Destination:=Range("D1:D131")
Range("D1:D131").Select

However I do not want the macro to define the D1:D131 bit as next time there may be more or less rows. What can I enter into the macro instead?

New to all this so any help is most appreciated.