Macro - Variable Dates

[chris778]

Hi All,

I need some help with a macro I am trying to develop. The basic idea is that I get my raw data file, and the macro runs across it removing all of the information which I don't need. The data I am using is produced in a format which repeats the date and headings on every page - once this is exported into Excel I therefore get multiple occurances of the date / headings. I had been using autofilters in the macro to sort / select and delete the relevant rows, but of course when it comes to dates this will change every day so the macro can't pick up these occurances. Is there a commend I can put into my macro which will look for occurances of today's date?

Thanks,


Chris

 

[texasalynn]

this will assign x as today's date

x = Format(Now() - 1, "mm-dd-yyyy")

HTH