Replacing cells with other cells

  • Thread starter Thread starter Gina
  • Start date Start date
G

Gina

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.
 
Is a standard day 8 hours?

Sub holiday()
ActiveCell.Value = 8
End Sub


Gord Dibben MS Excel MVP
 
Back
Top