Dates in excel

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

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?
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for Dates 5
Select random records by two conditions 1
Date criteria for adv. filter in code 3
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Sum work hours to hours & nearest 10th of an hour 14
Excel Message box with days of month & date. 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Check a value every time excel is loaded 1

Back
Top