Hi LEG.

I have just put up a worked example for you at:-

http://www.pierrefondes.com/

- home page (item number 24).

Please hit Yes if my comments have helped and / or my proposed solution is
correct.

My example is in EXCEL 2007.

Thanks.



"LEG" wrote:

Hi!
In my worksheet I have in coloumn A employees and in coloumn C and forward I
have every day in a two month period. F.eks. 1. november to 31. december (61
coloums in all). In each cell there is either a blank cell og a no. which
represents the no. of hours they worked that day.

I need a formula/macro/VBA ... which tells me how many days in a row each
employee had in the two month periode.

Any help would be great.

--
LEG-denmark