Code to clear specified cells of data, but leaving formulas

Hello Again,

I am seeking VB code or a macro that will automatically clear data entered into specific cells
of a single worksheet at 11:59:59PM each night.
It is important not to effect any Cell Formulas or Conditional Cell Formatting contained within that specific worksheet?
It is as equally important not to effect the entered data in other worksheets.

Thanks - Coop

Try this way

1. Place files:

A. start_almost_at_time_0.bat.txt
B. start_almost_at_time_0.vbs.txt
C. your xls file (in this case it's Book1.xls, just for a try)

in the appropriate catalogs (suited to your needs)

2. Change the file extensions to "bat" and "vbs" respectively for files in points A and B

3. To your "xls" file (standard module, e.g. "Module1"), copy the following macro:

Please Login or Register  to view this content.

and customize the sheet name ("Sheet1") and range of cells ("B2:F9)

4. Register "start_almost_at_time_0.bat" in the windows schedule (with triggering in a shorter period of time, e.g. 1 min.)
5. Check if it works, and if so, change the trigger for the target time (11:59:59PM)