Macro to copy data into a variable number of rows

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.

Try this

Please Login or Register  to view this content.

But the question how to determine the lastrow ?? based on what column?