Macro to give next # of Pay Period

[Robert1960]

I'm trying to fix up a macro for number of pay periods, but it keeps coming up as dates. What I'm trying to do is when I save my time sheets I want it to save with the number of pay periods on the sheet and start out the next time sheet with a new pay period number. If someone could help. http://www.excelforum.com/attachment...1&d=1470411615. I have have copy of my spread sheet attached so y'all can see what I'm doing. In cell A1 is the pay period number I would like for it the save and start out with a new number each time I use it.

[shg]

Please take a few minutes to read the Forum Rules about thread titles, and then amend yours accordingly.

Thanks.

EDIT: Thank you, Robert.

[Robert1960]

hopefully my amend is with in the guide lines of the Forum Rules

[shg]

Golden, thank you.