PHP Code:
If Toggler = 0 Then
With Range(Cells(RangeRow, 1), Cells(10000, 11))
Set rFind = .Find(What:=ExpTask, LookAt:=xlWhole, MatchCase:=False, SearchFormat:=False)
P6Task = Workbooks(SrcFile).Worksheets(DesSheet).Cells(rFind.Row, 1)
P6Disc = Workbooks(SrcFile).Worksheets(DesSheet).Cells(rFind.Row, 3)
ElseIf Toggler <> 0 Then
P6Task = Workbooks(SrcFile).Worksheets(DesSheet).Cells(DesRow, 1)
P6Disc = Workbooks(SrcFile).Worksheets(DesSheet).Cells(DesRow, 3)
End If
End With
Not seeing how there is a problem with this IF, ELSEIF, ENDIF syntax.
Am i not seeing the wood for the trees?
Cheers,
Bookmarks