Hi:

I used bcb office2k compment to control excel.

I use mouse to select a region (B2-D4).
What can i to know the region from my bcb program?

I try 3 function below:

1. range=ExcelWorksheet1-UsedRange[1]-CurrentRegion;
2.
range=ExcelWorksheet1-Cells-SpecialCells(xlCellTypeLastCell,EmptyParam);
3. range=ExcelApplication-ActiveCell;

everybody know ?

Thanks