I'm stumped - Using a macro to find a value greater than *blank*

[acollier21]

Hi All,

I've combed the internet and all sorts of different forums for help with this, but I can't find exactly what I need. Here's the basics:

I have two dates and I need to find the values in between those dates.

For instance I need to find the value >= A1 (which could be 10/1/2010) and the value < A2 (which could be 11/15/2010). These values will change dynamically with the spreadsheet I have.

So how do I do that in this macro in the "What:=" field?

Selection.Find(What:=What the heck do I put here????, After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Select

If you need more details of what I'm doing, I'm happy to oblige but I have everything else worked out but this problem.

Thanks in advance!

 

[shg]

Find won't work for that.

Via the user interface, you could Autofilter that column for dates in the range of interest.

 

[acollier21]

I was afraid of that......

I've used Range("A1").Value before for the "What:=" and that worked just fine. I wasn't sure if it was possible to set a bottom and a top range to find.....

Is it possible just to do one of conditions (for example just find any value that is >= A1)? If I could have at least one of those work, I could make it happen.

 

[acollier21]

Or is it possible to just use a regular excel formula to calculate this?

The basics of my spreadsheet is that certain dates that are entered into the cells have unique values placed next to them (10/1/2010 might have 5 next to it, but then in another cell with 10/1/2010 next to it could be a 4 instead). I need to find all the values with the date range and add up the numbers next to them.

Does that make sense?