How to change Macro to delete the " list of column name" from delete all but list of names

**capson** · 08-28-2013, 09:27 AM

How to change Macro so that it deletes the list of columns, as it works now it deletes everything not in the column.

I have tryed but could not get it.

Thanks

Please Login or Register  to view this content.

**Norie** · 08-28-2013, 09:46 AM

What are the headers of the columns you want to delete and which row are they in?

Please Login or Register  to view this content.

**capson** · 08-28-2013, 10:56 AM

Hello Norie,

Your code worked perfectly.

I would like to use your code to copy a list of columns and past them into a different sheet I tried (to no avail)

Please Login or Register  to view this content.

can your code be altered to do this?

**Norie** · 08-28-2013, 10:59 AM

Where do you want to copy the columns to in the other sheet?

**capson** · 08-28-2013, 11:02 AM

I want to paste them in the order they are in the list starting in column and cell A1

How to change Macro to delete the " list of column name" from delete all but list of names

LinkBack

Thread Tools

Rate This Thread

Display

How to change Macro to delete the " list of column name" from delete all but list of names

Re: How to change Macro to delete the " list of column name" from delete all but list of n

Re: How to change Macro to delete the " list of column name" from delete all but list of n

Thread Information

Users Browsing this Thread

Similar Threads

delete value of dependant list automatically when "mother-list" gets manually deleted.

Delete Row if Cells in specifc Column Equals "X" Macro Needed

"PICOBJ.DELETE" to remove shape: Problem when validation list populated

Help,, need macro to replace 'space' in list of names with "." (dot), then compare ss

[SOLVED] How to delete rows when List toolbar's "delete" isnt highlighted?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions