Copying into empty cells

[butlerar]

Hi

Need a macro, tried adapting other peoples code to work with mine but keep getting errors.

What i want to do is:

Copy cell range B17:AM46
Starting from cell B81 (same worksheet), paste into next empty cell.

I will tie this macro to a button so each time it's clicked the cell range will be copied.

That's it!

Help much appreciated.

Alex.

[butlerar]

Slight amendment to the above problem...

I want to copy every other row, that is - B17:AM17, B19:AM19, B21:AM21 etc etc, up to B45:AM45.

Also, if a row contains no data, say rows 31 to 45, then don't copy it.

Thanks,

Alex.