Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there any way to have a for/next loop to search a Column for
months? One specific column has inventory number information as well as date separators, the dates are in "mmm-yy" format. Sub FindDate() Dim FoundCell As Range Dim Mnth As Variant Range("InvNum").Select Mnth = ? For Mnth = Jan To Dec With Sheets("Job Sheet") Set FoundCell = .Cells.Find(What:=Mnth, _ After:=.Range("C2"), LookIn:=xlValues, _ LookAt:=xlPart, SearchOrder: _ =xlByRows, SearchDirection:=xlNext, _ MatchCase:=False) If Not FoundCell Is Nothing Then .Activate FoundCell.Select End If End With Next Mnth End Sub This is just testing code, I have many other actions waiting in anther routine I need to plug in after this gets done. Thanks for any help, Chad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate Revenue based on dates within a month | Excel Worksheet Functions | |||
Return dates based on month and day of week | Excel Worksheet Functions | |||
Dates - Several Days In a month to month only | Excel Discussion (Misc queries) | |||
Fill column with dates of month depending on month in A1 | Excel Programming | |||
How can i filter dates based on day of month | Excel Worksheet Functions |