Hi Guys,

As a part of a macro that i am doing, the amount of cases before th
week that is been worked on must be counted. Is there a way of coding
pop up to ask the user to enter the date to count back from.

i.e when compling the data for the week ending 30/06/04, all the date
before and including the 23/06/04 must be counted.


Is there any way of doing this through macro?
Any help on this would be great....

Thanks in Advance,
Cathal

--
Message posted from http://www.ExcelForum.com