Only copying/deleting columns from a table rather than the entire sheet

**Glade1825** · 03-01-2015, 07:58 PM

Hello!

Basically what I am looking for is how to make this macro not copy the entire row of data but only copy/paste/delete the columns from the table (A:Y).

Here is the current macro:

Please Login or Register  to view this content.

I will also attach the current spreadsheet so that you can get a better idea of what I am looking for. The reason I only want the table columns to be deleted is because anytime that I have to move an employee to the Terms tab, it moves up the dates that everything is calculated off of by 1, and causes issues with the rest of the sheet.

Thanks for any help you are able to give me as always.

2015 PTO tracker Hourly WIP.xlsm

**alansidman** · 03-01-2015, 08:17 PM

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 here

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

**Glade1825** · 03-01-2015, 08:25 PM

Sorry about that. Should be fixed now!

**stnkynts** · 03-01-2015, 08:42 PM

Moderator request has been fulfilled so I will respond to post.

This line here, as it says specified the whole row to be copied

Please Login or Register  to view this content.

There are a couple of ways to specify specific ranges to be addressed. One way would be like this

Please Login or Register  to view this content.

This will cover columns A to Y. Give this a try and let me know. Note: I only looked at your code, not your workbook because I think this solves you question. If it does not let me know and i will delve further into it.

**Glade1825** · 03-01-2015, 08:51 PM

Hi, I believe this would work but I get an error when I attempt Term someone the goes as follows:

"This operation is not allowed. The operation is attempting to shift cells in a table in your worksheet."

I assume that I would need to modify the end of the code to shift cells up after deleting but I am not sure how to do that.

**stnkynts** · 03-01-2015, 09:28 PM

when I attempt Term someone the goes as follows:

"This operation is not allowed. The operation is attempting to shift cells in a table in your worksheet."

What?!?

I assume that I would need to modify the end of the code to shift cells up after deleting but I am not sure how to do that.

The default of .Delete is to shift cell up. If you want to specify for safety sake you could do this

Please Login or Register  to view this content.

**Glade1825** · 03-01-2015, 09:42 PM

Well that error message still comes up, but it is not a big deal. I can just convert the table to range and it will work fine with filters. Once I do that it works the way I would like it to so thank you for your help! I greatly appreciate it.

Only copying/deleting columns from a table rather than the entire sheet

LinkBack

Thread Tools

Rate This Thread

Display

Only copying/deleting columns from a table rather than the entire sheet

Re: Only copying/deleting columns from a table rather than the entire sheet

Re: Only copying/deleting columns from a table rather than the entire sheet

Re: Only copying/deleting columns from a table rather than the entire sheet

Re: Only copying/deleting columns from a table rather than the entire sheet

Re: Only copying/deleting columns from a table rather than the entire sheet

Re: Only copying/deleting columns from a table rather than the entire sheet

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Comparing data in two different columns and deleting entire row

[SOLVED] Copying the entire row from TABLE A that meets certain criteria to another Table

Macro is deleting entire table when no values return in a criteria.

Deleting An Entire Row if Date is not Today in Any One of Three Columns

Macro for Deleting the entire row if first two columns are blank

Bookmarks

Bookmarks

Posting Permissions