Replacing cells with other cells
Is a standard day 8 hours?
Sub holiday()
ActiveCell.Value = 8
End Sub
Gord Dibben MS Excel MVP
On Mon, 23 Jun 2008 05:19:00 -0700, Gina wrote:
I have recently set up a time sheet for myself at work. At my last place you
could click on a button called 'Annual Leave' or 'Bank Holiday' and the cells
would be filled with a standard day. Does any one know how this is done? I
would like to add it to my time sheet if poss.
|