On Fri, 13 Oct 2006 21:39:02 -0700, MCH
wrote:

I have a Macro button which is used every month to do a SAVE AS the problem
is I have to go in the macro every month and change to the current month,
Does any one know of a way to get the macro to change the month.

The technique I usually use in a case like this is to hold the month
number or name in a named range variable, and use this variable within
the macro code which saves the filename.

Typically month numbers or names appear somwhere in data sheets or
reports anyway, so it's usually just a matter of naming the
appropriate cells. Or better still keeping all your variable names,
like month number etc., in once place, and having them refer to
specific cells.

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________