Clear Column every minute

[Zipping2010]

Hi All,

How do I clear the data from Column D every minute using a macro?

Thanks for your help.

Cheers,

Andrew

[J.Green]

This code is located in Module 1:

Please Login or Register  to view this content.

[Zipping2010]

Thanks so much. Your comments are very helpful and it is exactly what I need.

Cheers,

Andrew

[J.Green]

Your welcome.

[Zipping2010]

One quick one, how do I apply this to every sheet in the workbook?

Thanks

[J.Green]

This is one method. Change the code in the appropriate section:

Please Login or Register  to view this content.

[jaslake]

Hi Zip

Another approach...

Please Login or Register  to view this content.

[Zipping2010]

Thank you both for your help! Works great!

[J.Green]

Cheers !