DougRobertson
Active Member
- Joined
- Sep 22, 2009
- Messages
- 334
- Office Version
- 365
- Platform
- Windows
Hello,
I have created numerous Macros where I use the VBA Find function to find the Row Number where a certain Text is first located.
However I now need to do the same thing, but instead of finding a certain Text, I need to Find a Date . . . . so to speak!
Here's what I have so far.
Thanks in advance for any and all help on this!
[/FONT]
I have created numerous Macros where I use the VBA Find function to find the Row Number where a certain Text is first located.
However I now need to do the same thing, but instead of finding a certain Text, I need to Find a Date . . . . so to speak!
Here's what I have so far.
Code:
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]Dim iTHISMonthYear As Date
[/FONT]
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]iRowNumber = Range("A4:A100").Find(what:=iTHISMonthYear, LookIn:=xlValues, After:=Range("A1")).Row
Thanks in advance for any and all help on this!
[/FONT]