Excel VBA code.

[drewduncan]

Can anyone help:

I am trying to create a Holiday Schedule in Excel.

Every month is on a different page.

Each member of staff is colour coded.

Cells will be colour coded to show who is on holiday when.

I would like to have a field on each page to show the total number of holidays taken for each month for each member of staff.

The only way i can think of doing this is by 'adding the like coloured cells together'.

Can this be done in VBA Code?

Or does anyone else have a better idea.

Thanks in advance

 

[arthurbr]

Maybe this link can help :

http://groups.google.com/groups?oi=djq&ic=1&selm=

an_464294863

 

[Dreamboat]

or this one:

http://www.cpearson.com/excel/colors.htm

Anne Troy

http://www.VBAExpress.com