Delete row after 120 days

[AC]

I have a date in column C, I want to delete the whole row when this date is 120 days old based on the current day,=Now(). Can this be done? Thanks I am using Excel '97
This message was edited by ac on 2002-03-22 12:19

 

[Legacy 1363]

On 2002-03-22 23:22, Ivan F Moala wrote:

Last thing -- the Application.ScreenUpdating = True is unnecessary at the end of the routine, as Excel defaults back to true at the End Sub.

Thanks for your post,
Jay

Jay....screenupdating doesn't default back to true.

Ivan
[/quote]


Oh?
According to Microsoft it does, except for one exception.
The exception results from a situation that's not a common one.
For details see Article Q213606 in the MS Knowledge Base.

 

[Ivan F Moala]

On 2002-03-22 23:38, C. O. Jones wrote:

On 2002-03-22 23:22, Ivan F Moala wrote:

Last thing -- the Application.ScreenUpdating = True is unnecessary at the end of the routine, as Excel defaults back to true at the End Sub.

Thanks for your post,
Jay

Jay....screenupdating doesn't default back to true.

Ivan

Oh?
According to Microsoft it does, except for one exception.
The exception results from a situation that's not a common one.
For details see Article Q213606 in the MS Knowledge Base.

[/quote]

Yes this is true in that the Screen resets
(Excel2000+ only) BUT the status for
screenupdating is still set to False within
the program....

Help File States..
ScreenUpdating Property

True if screen updating is turned on. Read/write Boolean.

Remarks

Turn screen updating off to speed up your macro code. You won't be able to see what the macro is doing, but it will run faster.

Remember to set the ScreenUpdating property back to True when your macro ends.

So I genearally always reset this in the program
especially for backwards compatibilty PLUS
the fact that most of my routines are called
from others and may / may not require the screen update.



Ivan

 

[AC]

Thanks everyone I ended up using Jay's, with the screen updated added, thanks to Ivan. Thanks for all the help, great site, lots of people helping each other out
This message was edited by AC on 2002-03-23 06:50