VBA Macro Button to delete entire row

Hey Guys,

I'm fairly new to VBA and im trying to find code to copy an entire row, paste it to another worksheet, then delete the entire row where the button is; including the button. But I want to have a button at the end of each row. I got the copy and paste down, but im having trouble with the command to delete only the row that the button is in. I'm trying to select the cell that the top left corner of the button is in, but I cant get it to work. This is what I have.

Please Login or Register  to view this content.

It would also be great if I could create a new row with the formulas from the other rows, so I don't have to have a 100 blank rows. Thanks in advance!

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Sorry Freind


Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Thanks Alan

I can now reply.


1. Why would you want a button on each row? You can have a macro run on :-

Double Click
Right Click
Pressing ctrl and a key.

Dealing with numerous button is a pain and frankly pointless

Ok

I created this Macro:-

Please Login or Register  to view this content.

I can run this selecting Developer, Macros, Select Macro1 and then run.

However if I select Developer, Macros,Macro1 and then options, I can enter a letter like "d" into the shortcut box.

Now if i hold down the ctrl key and press "d" the Macro will run.

****************************************************************************************************************************

If I right click on the sheet name at the bottom of excel and select view code.

A module opens.

If I paste this code in that module and close it.

Please Login or Register  to view this content.

My Macro will also run if I doubleclick or right click.

Ok

You still do not need any buttons.

If we consider my Macro1.

If I right click on the sheet name at the bottom of excel and select view code.

A module opens.

If I paste this code in that module and close it.

Please Login or Register  to view this content.

So this time the macro will run if all these criteria are true
I only select one cell
I select a cell in column V
Column B in that row is not empty
The row number is 16 or more

You could specify that the selected cell in column V must contain the text "Transfer to Archive"

Please Login or Register  to view this content.

This is still a lot tidier then having all those buttons.

There were three issues

1. Your workbook was corrupt

2. I had an error in my macro

3. You need two macros. Sheet specific macros only work on the host sheet.

So

Please Login or Register  to view this content.

This looks Ok.

The problem is probably in the main macro.

Have you managed to create an endless Loop?

if all your rows look like they are ready to copy then it is possible yo set it up so the macro loops around.

insert

Please Login or Register  to view this content.

at the start of your macro

and insert

Please Login or Register  to view this content.

at the end of your macro