[solved] How to activate/show/focus cells

[Raumgleiter]

Hello forummembers,

I use the FPSearchengine to find cells in a workbook with a couple of worksheets.
The result of the search is stored in a stringlist with the information of cell and worksheet
Now I try to "search backwards". That means, I will show  the found cell/worksheet on screen.
I have no problems to show the found worksheet, but if I try to show/focus/activate the found cell on screen I fail.
I see one of the cells in the found worksheet but not the found one from the stringlist.

My question: How to show/focus/activate a cell on a shown worksheet.

Thanks in advance.

[wp]

Code: Pascal  [Select][+][-]

1. // Select cell B5
2. // "B5" is in the worksheet in row 4 and column 1
3. // Note: this is different in the grid which is offset by the fixed rows/cols
4. procedure TForm1.Button1Click(Sender: TObject);
5. begin
6.   sWorksheetGrid1.Worksheet.SelectCell(4, 1);
7.   // or
8.   {
9.   sWorksheetGrid1.Col := 2;
10.   sWorksheetGrid1.Row := 5;
11.   }
12. end;

[Raumgleiter]

Thanks WP,

your help solves my problem.