smartpat19
Board Regular
- Joined
- Sep 3, 2014
- Messages
- 114
HI All,
Working on my first find function. I am trying to return the range. The formatting is dates and I am trying the find what cell the date is in row 7. Right now I am returning nothing.
Thank you
Working on my first find function. I am trying to return the range. The formatting is dates and I am trying the find what cell the date is in row 7. Right now I am returning nothing.
VBA Code:
Sub Retainage_Macro()
Dim proforma As Workbook
Set proforma = ActiveWorkbook
Dim master As Workbook
Dim Current_Month As Range
Set Sht = Sheets("Project Summary")
Set cfs = Sheets("Cash Flow Template")
Start = cfs.Range("E1").Value
Set Current_Month = cfs.Range("7:7").Find(What:=Start, Lookat:=xlWhole, MatchCase:=False)
MsgBox (Current_Month)
Thank you