Excel 97 - Today() - Month as ActiveSheet.name

[Wicca]

Merry Meet,
As I am sure many of you do, I have 12 sheets named
January thru December.

And, again, as I am sure many of you do I manipulate the data within those sheets.

Question?
After I have been manipulating data like a good the good little boy I am, HOW do I get it to go back to the page with this month as its Name....eg March

I have been reading VBA at different sites for 3 days, its now 12.30pm on Sunday, and before I can put my Spectacles on I have to do a mental

Spectacles.select
Selection.copy
Nose.Select
Selection.paste

....sorry just having some fun.

PLEASE PLEASE help me

Merry Part
With respect
Wicca

 

[Wicca]

Merry Meet all

Well, Just shows dont it?

Spent more time looking around and found this awesome FAQ
faq68-4037

It gave me this formula that appears to do the job nicely thank you very much

=TEXT(TODAY(),"MMMM")

It converts my Today() to a text MONTH....

SOOOOOOOOOOo right now I am on seventh heaven
I can go spend the rest of my weekend with my family

Merry Part
With respect
Wicca