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
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion