Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finds date but won't change cell
Can some one tell me why it won't change cell H12
It finds the date -- Range("F5").Select Cells.Find(What:="3/1/2006", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _ MatchCase:=False).Activate If ActiveCell = 3 / 1 / 2006 Then Range("H12").Value = 1 Esau |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula the finds value of cell above | Excel Discussion (Misc queries) | |||
Excel 2003 make 1 date cell automatically change another date cell | Excel Worksheet Functions | |||
Need a formula that finds the last used cell in a range | Excel Worksheet Functions | |||
I want tool which finds duplicate date in excel 2003 | Excel Worksheet Functions | |||
a macro which finds last cell in a column | Excel Programming |