completely clear all rows after date

**Directlinq** · 03-04-2009, 05:09 AM

Is there some vba code that will completly remove all rows after a certain date in A column, the date is in B2. Dates are listed in A column.

When i say completely remove i mean delete, clear colours, remove borders,etc etc

Thanks

**DonkeyOte** · 03-04-2009, 05:27 AM

Perhaps:

Please Login or Register  to view this content.

**Directlinq** · 03-04-2009, 05:36 AM

That deletes the cells great but does not remove internal colours or boxes etc.

**DonkeyOte** · 03-04-2009, 05:40 AM

It deletes the rows in their entirety thus including any/all formatting on said cells.

Are you running any VBA Events to set Formatting ?

**Directlinq** · 03-04-2009, 05:42 AM

yes but this macro runs after the formatting macro has finished.

**DonkeyOte** · 03-04-2009, 05:45 AM

I have no idea what that means.. are you're formatting via a standard Sub Routine or via an Event ... if it's an Event (ie Worksheet_Change) then it doesn't matter what you do the Event will always fire and reformat the ranges as specified.

Rather than guessing I would suggest you actually post a sample file with code so we can see what's happening.

**Directlinq** · 03-04-2009, 06:21 AM

Sorry the formatting is a subroutine

**Directlinq** · 03-04-2009, 06:24 AM

sorry got it sorted thanks for your help

completely clear all rows after date

LinkBack

Thread Tools

Rate This Thread

Display

completely clear all rows after date

Re: completely clear all rows after date

Re: completely clear all rows after date

Re: completely clear all rows after date

Re: completely clear all rows after date

Re: completely clear all rows after date

Re: completely clear all rows after date

Re: completely clear all rows after date

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions