Hi,

am trying to past data from selection to first empty cell in a range. Have worked around it for simple sheet just by inserting new row, but this isn't any good for a sheet that has columns being totalled...

The aim is to hit the button, paste selected data into first empty cell in range, but if all cells populated to go and do the same in a different range - eg a continuation page. The reason for this being that if I add new rows, the print range changes and will no longer fit onto the page (this is an invoice with subtotals/totals that are cleared when page is full and the 2nd page takes over...).

Hope this is clear - seems that either all my problems are difficult to explain or I'm no good at explaining!!!!!

Many thanks,

Mark