I have a script in where it copies a sheet's data, and pastes it, but over pastes...

Here is my script.

Please Login or Register  to view this content.

It technically works perfectly till here:

Please Login or Register  to view this content.

Now technically everything in this part works correctly, but the last line in the code, it pasts everything correctly, then it goes one step beyond. I'd like to know why. If I get rid of the offset it overwrites what is in the cell above in O through S. I need to know the first and last cell, because the data needs to be only written to a specific cell range.

If there is an easier way of doing this it be appreciated if someone could tell me, if not then can someone tell me how to fix this?

Thanks.

Attached is a workbook.

http://dl.dropbox.com/u/3327208/Exce...6LastRows.xlsm

Have you tried:

Please Login or Register  to view this content.

Wallyeye

Use code tags for all code in posts