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.
Nevertheless, the following macro does that. Note that statements 3 and 4 in the snippet below are two alternative ways of clearing the values in J10J1000. The first one puts two double quotes in those cells. The second removes all values.
Put the following code in ThisWorkbook code pane. It won't work at all if installed anywhere else.
Open in new window