Mike

You can do this in a couple of ways - one that doesn't need to use VBA is:

Go into Insert, Name, Define

Create the "variable" name BeginMonthDate in the "Names In Workbook" box and
enter the following in the "Refers To" box:

=EOMONTH(Sheet1!$F$5,-1)+1 <------ Requires Analysis toolpak to be
loaded
(change to refer to your sheet)

This name can then be used as a variable in any workbook in the normal way
or can be used in VBA by referring to it in square brackets -

e.g. MyStartMonth = [BeginMonthDate]

HTH

Giles

"mikeburg" wrote:


What would be the VBA code to determine the begin month date from the
month end date in cell F5 AND put in a variable named BeginMonthDate.

For example:

F5 = 09/30/2005
need BeginMonthDate to equal 09/01/2005

or

F5 = 12/31/2005
need BeginMonthDate to equal 12/01/2005

Thanks a million. mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=501127