I have a very simple vba macro, but I would delete row after I cut row to another sheet

**Deductedsolid** · 08-25-2020, 10:34 PM

I am new to vba macros and need help. I have a very simple vba macro, but I would like delete row after I cut row to another sheet and then shift remaining cells up

Please Login or Register  to view this content.

**alansidman** · 08-25-2020, 10:44 PM

Code Tags Added
Your post does not comply with Rule 2 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.)

**jindon** · 08-25-2020, 10:47 PM

try something like this

Please Login or Register  to view this content.

**Deductedsolid** · 08-25-2020, 10:47 PM

Ok, thank you.

**Deductedsolid** · 08-25-2020, 11:00 PM

I'm getting an error on the last End If "end if without block if"

**jindon** · 08-25-2020, 11:04 PM

OOps, the code has been edited.

You could also do it with AutoFilter, if you have header.

**Deductedsolid** · 08-25-2020, 11:10 PM

Now I'm getting an error

Please Login or Register  to view this content.

line. Sorry I'm new to vba and struggling

**jindon** · 08-25-2020, 11:14 PM

Can you show me the whole code?

**Deductedsolid** · 08-25-2020, 11:15 PM

Please Login or Register  to view this content.

**jindon** · 08-25-2020, 11:16 PM

And what kind of error are you getting?

**Deductedsolid** · 08-25-2020, 11:18 PM

Please Login or Register  to view this content.

it turns yellow and says delete method of range class failed

**jindon** · 08-25-2020, 11:23 PM

Then I need to see your workbook, as it is working here.

**jindon** · 08-25-2020, 11:27 PM

Or is the worksheet protected?

**Deductedsolid** · 08-26-2020, 06:42 PM

I ran my first macro and manually deleted columns then changed to your macro and yes it works. Thank you jindon

I have a very simple vba macro, but I would delete row after I cut row to another sheet

LinkBack

Thread Tools

Rate This Thread

Display

I have a very simple vba macro, but I would delete row after I cut row to another sheet

Re: I have a very simple vba macro, but I would delete row after I cut row to another shee

Re: I have a very simple vba macro, but I would delete row after I cut row to another shee

Re: I have a very simple vba macro, but I would delete row after I cut row to another shee

Re: I have a very simple vba macro, but I would delete row after I cut row to another shee

Re: I have a very simple vba macro, but I would delete row after I cut row to another shee

Re: I have a very simple vba macro, but I would delete row after I cut row to another shee

Re: I have a very simple vba macro, but I would delete row after I cut row to another shee

Re: I have a very simple vba macro, but I would delete row after I cut row to another shee

Re: I have a very simple vba macro, but I would delete row after I cut row to another shee

Re: I have a very simple vba macro, but I would delete row after I cut row to another shee

Re: I have a very simple vba macro, but I would delete row after I cut row to another shee

Re: I have a very simple vba macro, but I would delete row after I cut row to another shee

Re: I have a very simple vba macro, but I would delete row after I cut row to another shee

Thread Information

Users Browsing this Thread

Similar Threads

Simple Macro to Delete an Excel file at a specific Folder Location

Run a simple goalseek macro in every sheet except a few

Simple macro to search text and delete any plus signs

Simple Macro: Delete mail in certain folders

[SOLVED] Simple macro to create list of sheet names and the contents of cells A1 & N1 of each sheet

Write a simple Macro to delete every alternative rows (1, 3, 5...)

Simple MACRO to delete words not required in ROWS

Bookmarks

Bookmarks

Posting Permissions