Counting columns using VBA

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I want to be able to count the number of days an employees
had taken hols.

I have set up a spread*** which indicates this

It is possible using VBA to count 5 columns out of every 7
for the entire year and output the results to another
spread***. I will always start on the 1st monday and
will be dealing with around 250 employees (rows)

Thanking you in advance
Marcus
.

Quantcast