Copying to a flexible range

[johncpa]

I want to copy a formula using a macro but the ending part of the range can
change. For example, the user inputs the current age and a retirement age
and the retirement age can change. How do I create a macro that can allow
the range to be flexible, i.e. 15 years, 20 years, etc. I can copy the
formula manually to the ending range but I want to be able to have a macro
perform this automatically. Any help would be appreciated.

 

[Don Guillett]

lastrow=cells(rows.count,"a").end(xlup).row
range("b12").copy range("a"&lastrow)