Macro?

[mscanavino]

Hey guys i have no clue really how to do macros but i need help with this macro for work.


I have a spreadsheet that has values in currency, percentages, and text fields. What I need the macro to do is at a certain time (id like to pick the time) is clear the cell values but keep the formats of each cell.

if you have any questions please ask thanks

 

[Jaye7]

Just click at the top of your page which highlights the whole spreadsheet and click the delete button, the values are deleted, however the formatting is retained.

 

[mscanavino]

But I don't want the whole spreadsheet to be erased just a certain range of cells. I would like it to be automatically erased at like 3 in the morning and then saved so it is like a new spreadsheet for the next day. You get what i mean?

 

[Jaye7]

For something to run at 3.00am in the morning you are best to use windows task scheduler and when it opens the workbook then it will run the delete code for your range or you can use a wintimer, but windows scheduler would be best, use google to look up windows scheduler.

 

[Smitty]

Welcome to the Board!

I agree with using the Windows Scheduler. As for the code itself you can record a macro doing what you want, then call it in the Open event, which will fire if you have Scheduler open the workbook.

HTH,