converting a VBA code in C#

Awesome!

Ketan, Thanks you very much :-)

Thanks, With your help I reached with this code but:

long Lrow = 0;
long LColumn = 0;
xlWorkSheet.Activate();
int dataCount = (int)xlApp.WorksheetFunction.CountA(xlWorkSheet.Cells);

if (dataCount == 0)
{
// All cells on the worksheet are empty.
}
else
{
// There is at least one cell on the worksheet that has non-empty contents.
{
Lrow = xlWorkSheet.Cells.Find(What: "*", After: xlWorkSheet.Cells[1, 1], SearchOrder: xlByRows, SearchDirection: xlPrevious).Row;

LColumn = xlWorkSheet.Cells.Find(What: "*", After: xlWorkSheet.Cells[1, 1], SearchOrder: xlByColumns, SearchDirection: xlPrevious).Column;
}
}

shows Error in the above code.

long Lrow = 0;

long LColumn = 0;

Sheet1.Activate();

if (WorksheetFunction.CountA(Cells) > 0) {

    Lrow = Cells.Find(What: "*", After: A1, SearchOrder: xlByRows, SearchDirection: xlPrevious).Row;

    LColumn = Cells.Find(What: "*", After: A1, SearchOrder: xlByColumns, SearchDirection: xlPrevious).Column;

}

 

I have converted this using a free online tool from Telerik. Check following link-

http://converter.telerik.com/

 

 

Hope, it helps :)