Results 1 to 10 of 10

Macro to Clear contents in a range of cells when Date change.

Threaded View

  1. #1
    Registered User
    Join Date
    12-04-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    91

    Macro to Clear contents in a range of cells when Date change.

    Friends,

    I have a work sheet and on that I have datas in A7:A50. I need to clear the contents in that cell when the date change. More clearly. I am using that column for Remarks and, if I wrote something on that column being used only for today. next day morning I want that columns to be cleared. Kindly provide me a Macro for the same.
    Last edited by aneshdas; 01-06-2014 at 02:14 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] I need a macro to clear cells based on contents
    By emymeeky in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-28-2013, 08:54 AM
  2. Macro to Clear Contents of Cells when one cell = 0 %
    By BVT3030 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2013, 02:55 AM
  3. Replies: 6
    Last Post: 06-05-2013, 12:14 AM
  4. Replies: 18
    Last Post: 02-10-2013, 05:32 PM
  5. Clear contents of cells in a range, LEN=0
    By jenny_journalist in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-29-2009, 11:37 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1