If row got certain value keep it's column but delete the other columns?

**Frederic01** · 08-17-2016, 06:40 AM

Hi, I got several sheets with 200+ columns.

For every sheet, I want the macro to check row 6 of a column, and if the row contains a certain value, it
will keep that column but those columns who don't have the value will be deleted.

I have already tried with this script:

Please Login or Register  to view this content.

On the fourth line I get error: "Object required"

Can someone explain why?

**walruseggman** · 08-17-2016, 10:45 AM

You haven't defined what NMBW is.

If row got certain value keep it's column but delete the other columns?

LinkBack

Thread Tools

Rate This Thread

Display

If row got certain value keep it's column but delete the other columns?

Re: If row got certain value keep it's column but delete the other columns?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macros - Delete Columns, Cut & Paste Columns then Sorted by Column

delete three columns of two grouped columns according to common value of two column

Delete all columns if value in row 2 of that column is x?

If column contains certain header, delete column--exempt certain columns

Macro to delete certain columns and delete rows based on time in another column

Delete columns where the last row in the column = 0

Delete multiple columns by column name no criteria need, just delete them

Bookmarks

Bookmarks

Posting Permissions