You can use this code to create that function. It will look for the value and activate it:
Dim wb As Object
wb = GetWorkbook(Handle, Workbook)
wb.activesheet.Cells.Find(What:=Cell_value).Activate
You need the handle, workbook ...
Hi Nitesh,
I am using the same functionality and I split it up in two phases:
1) 'find cell based on value' in the MS excel VBO
2) I created a function myself withing the MS excel VBO called 'Offset Active Cell', based on some code:
Dim...
