Macro to add new row

[Fisher1975]

Hi

I have a tab with a list of data, what I want to do is setup a macro that copies a hidden row and inserts it at the bottom of the list.

How can I go about this?

 

[Andrew Poulsom]

Which row do you want to copy?

 

[Fisher1975]

At present it is row 135, but this will change when I insert new rows.

Maybe I should have this row at the top of the sheet and then it will always be row 1

 

[nuked]

Or you could just give the range a 'name'.

 

[Fisher1975]

Or you could just give the range a 'name'.

Yes, that is probably a better idea