|
|
#2
07-19-2018, 06:48 PM
|
||||
|
||||
Code:
Dim Rng As Range Set Rng = ActiveSheet.Cells.Find(What:="May", LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=True) MsgBox Rng.Address
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| if cell contains date, then month, else blank | Merlot | Excel | 7 | 03-20-2025 08:16 AM |
 Auto update excel graph range, ignore data when date reads 00-Month-00
|
SavGDK | Excel | 2 | 06-24-2016 08:05 AM |
| Excel day date month year Function | greginky | Excel | 1 | 01-05-2016 02:19 AM |
|
Filter by a Month that falls within a date range
|
MattG1225 | Excel | 2 | 12-03-2015 07:44 AM |
| Formula to subtract one month from due date field in reminder field | ghumdinger | Outlook | 1 | 10-01-2011 12:09 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode