Rev. Night
[H]ard|Gawd
- Joined
- Mar 30, 2004
- Messages
- 1,489
i am trying to write a macro that when enabled, it opens up a new page and names it a month (November). I need to code it so when i click it again, another new page comes up as Decemeber, and again one comes up as Jan. and so on.
i figured the code is something like:
ActiveSheet.Name = Month + 1
but i don't knwo how to implement it. Help me.
i figured the code is something like:
ActiveSheet.Name = Month + 1
but i don't knwo how to implement it. Help me.