Macro to filter the same column regardless of changes

**Barking_Mad** · 07-16-2010, 07:05 AM

Hi,

I’ve recorded a macro to run a filter (as below) it and it works fine. The only problem I have is that sometimes a column will be added, or possibly removed from the sheet - meaning the filter won’t always work. Is there a way to make sure the filter always does what it does on the same column, regardless of any changes to the column's location?

Please Login or Register  to view this content.

**pike** · 07-16-2010, 07:30 AM

Hi Barking_Mad,
Possibly if you know the field title eg if the coulmn title is "Two"

Please Login or Register  to view this content.

**Barking_Mad** · 07-16-2010, 07:46 AM

Hi Pike,

Thanks, but im having trouble getting the compiler to accept the code....im crap at VBA so please excuse..It's giving me a synstax error

Please Login or Register  to view this content.

Additionally, should i delete

Please Login or Register  to view this content.

from the original code?

**pike** · 07-16-2010, 07:51 AM

Hi Barking_Mad
Could you attach the workbook?

**Barking_Mad** · 07-16-2010, 08:41 AM

Here you go, ive taken bits and pieces of sensitive info out, but the column i want to filter is the ANNOTATIONS one on the end of the sheet, namely anything with LATE in the column of cells..

**pike** · 07-16-2010, 08:00 PM

Dude try this...

Please Login or Register  to view this content.

**pike** · 07-17-2010, 02:35 AM

Barkingmad
also removed the merged cells

**Barking_Mad** · 07-21-2010, 08:16 AM

Thanks Pike

Macro to filter the same column regardless of changes

LinkBack

Thread Tools

Rate This Thread

Display

Macro to filter the same column regardless of changes

Re: Macro to filter the same column regardless of changes

Re: Macro to filter the same column regardless of changes

Re: Macro to filter the same column regardless of changes

Re: Macro to filter the same column regardless of changes

Re: Macro to filter the same column regardless of changes

Re: Macro to filter the same column regardless of changes

Re: Macro to filter the same column regardless of changes

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions