I am trying to search for something on the spreadsheet. my code to search is below. the text I am searching for is this :
"COST REQUEST
EFF. DATE"
Set FoundCell = SearchRange.Find(What:="COST REQUEST EFF.Date", _
After:=LastCell, _
LookIn:=-4163, _...