On Friday, May 30, 2014 7:16:05 PM UTC-7, GS wrote:
No! Do it this way...



Set wksTarget = Sheets(Format(Date, "mmm yy")) 'Jan,Feb...



OR



Set wksTarget = Sheets(Format(Date, "mmmm yy")) 'full name



--

Garry

The 14 is a day not the year. You were referring to 2014 I think.

I'm thinking name change is a good idea.

Howard