Frank
I have an excel sheet with one column with dates entered,
other columns consist of data occuring on those dates. I
have another sheet with rows of the months of the year
and columns which require the data to autofill(via a VBA
program) from sheet1 dependant on the date previously
mentioned.Specifying dates between or particular months
is causing me the problem.

-----Original Message-----
Hi Eric
could you give some more details?
- do you want to test cells within a manual started macro
- do you need to run the macro automatically (an event
procedure)

Best way: You may provide an example of what you're
trying to achieve:
- name some cell values
- describe what should happen


--
Regards
Frank Kabel
Frankfurt, Germany


Eric wrote:
I would like code to run if the criteria of a range is
between two dates (ie a particular month) what code do
I
require for this?
.