In a excel sheet I want to search for the occurence of $currRepTitle in the range and select the cell which at the right(3 positions) of that particular occurence and mark it as "Y". See attached. How to accomplish this...
$currRepTitle = "aaa"
_ExcelSheetActivate($oExcel, "Report List")
$oExcel.Application.ActiveSheet.Range ("A1:C200").Find ($currRepTitle).Select
$oExcel.Application.ActiveCell.Offset ($aa).Select
$oExcel.Application.ActiveCell.Offset (0, 3).Select