Macro to Copy and Paste to new sheet

Closed
Nicklt - Aug 17, 2010 at 08:18 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 18, 2010 at 12:03 AM
Hello,

Im not great with excel macros and VBA so bear with me.

I want to create a macro that will Copy and then paste the current highlighted selection onto a new sheet.

I have this code -

Sub CopySelection()


Selection.Copy Sheets("Approved & Completed").Range(Selection.Address)


End Sub

Which copies and pastes the selection into the same range on the new sheet (Approved & Completed)

Problem is once this have been done the user then deletes this record from the first sheet and new info is put in it's place, which, when copied across overrites what is currently there.

What i want is a macro that copies the selection to the new sheet into the next empty row.

Sorry if this is confusing, thanks in advance.

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 18, 2010 at 12:03 AM
Not enough information to give you a good answer. But it seems that you need to find out the last used row
1