wolf.stalker
11-11-2008, 11:02 PM
hey all. i am having a pickle of a time trying to make this work....i need to find a date that is between E2:BG2. (note two things. E2=10/27/2008 and then G2=E2+1; I2=G2+1; etc. also...each date is merged between two cells. so the first one E2 actually is E2:F2...if that helps.
now, i have looked around and tried to figure this out, but i have got to be missing something. I can use this....
Cells.Find(What:="chico", After:=ActiveCell, LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext,
MatchCase:=False) _
.Activate
and it puts me on cell A121 (which is where part of that word resides) but I can NOT get it to find my date.!
anyone able to help me out a bit?
now, i have looked around and tried to figure this out, but i have got to be missing something. I can use this....
Cells.Find(What:="chico", After:=ActiveCell, LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext,
MatchCase:=False) _
.Activate
and it puts me on cell A121 (which is where part of that word resides) but I can NOT get it to find my date.!
anyone able to help me out a bit?