I am trying to do a "reset" every time I open a workbook. Specifically I would like the worksheet ("BegDay") to do the following in the range J10:J1000
'Place the number 1,000,000 in each and every cell of the range of J10:J1000
'Then immediately place "" in each and every cell of the range of J10:J1000
This should happen every single time the work book opens.