Can I get excel to recognize that the range April 05 to July 05 also
includes May and June?

I am trying to create a macro that populates a range of dates. I am
making a project allocation tool that will involve an input sheet and a
seperate sheet for each month.

I want it so that if you enter a range of dates (ex. 4/05-9/05)the
project will eventually appear in every sheet in its range.



Thanks for your help

You would need to parse the string entry and convert each half to the
respective date. then it should know about May and June.

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
Can I get excel to recognize that the range April 05 to July 05 also
includes May and June?

I am trying to create a macro that populates a range of dates. I am
making a project allocation tool that will involve an input sheet and a
seperate sheet for each month.

I want it so that if you enter a range of dates (ex. 4/05-9/05)the
project will eventually appear in every sheet in its range.



Thanks for your help