Have you labelled the cells like
1 2 3 . . .
Jan
Feb
Mar

Or are the months numbers? Where does the data start (where is the blank
cell in the upper left corner if you used organization like the above? ) It
takes specific information to provide sample code.

In what cells are the beginning data and end date entered? Are these
entered as true date values?

Based on the information provided,

you can loop down the column till you find the proper month or just
calculate it. then loop moving to the right until you meet either the end
date or the end of the month. If end date, stop. If end of month, come
back to column 2 of the next row.

--
Regards,
Tom Ogilvy



"Gabriele C " wrote in message
...
Hello!Sorry for my poor english....
In sheet(1) of my workbook,user inserts two dates,beginning and end of
a period.
In sheet(2) I have created 12 rows (months) and 31 columns (days)
I would like to make the program check the period inserted by user in
sheet(1) and then mark with a "x" every related cell in sheet(2).
I'm not able to find the solution...
Is there anyone who can help me?
Thank you very much,any idea or suggestion would be very appreciated.


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