without VBA, you can just copy/paste the value from A1 to A10.
or add a formula in A10:

=A1

with VBA, just Record a Macro.