Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try the following. Note the comments.
Sub FindNext() Dim myRange As Range Dim answer As Date Dim rngFound As Range Set myRange = Worksheets("Sheet5") _ .Range("K2:K80") answer = Application _ .WorksheetFunction.Min(myRange) Set rngFound = myRange _ .Find(What:=answer, _ LookIn:=xlFormulas, _ LookAt:=xlPart, _ SearchOrder:=xlByRows, _ SearchDirection:=xlNext, _ MatchCase:=False, _ SearchFormat:=False) MsgBox ("The next date is " & _ Format(answer, "mm/dd/yy")) 'because this code could be run when 'another worksheet is active you must 'ensure the correct worksheet is active 'before activating cells. 'Also Activate is not necessarily the same 'as Select. You can Activate a cell in 'a selected range.(It is the cell that is 'still white color.) Select a cell means 'it is the only selection Worksheets("Sheet5").Select rngFound.Cells.Activate rngFound.Font.ColorIndex = 3 End Sub -- Regards, OssieMac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change the color the cell becomes when doing a FIND | Excel Discussion (Misc queries) | |||
Find text in cell based on color value of another cell | Excel Programming | |||
Find the next Cell with interior color using Do Until...Loop | Excel Programming | |||
.Find cell within rng when font color=3 | Excel Programming | |||
Find purple cell color, change to red | Excel Programming |