When my worksheet is loaded I want to default in the following statement:

Range("B2").Value = Date - 1

There does not appear to be an on load event (or I should be using something
besides the worksheet).

Please give suggestions on the event to use.

as always,
Thanks