hey

i hope you can help me

i use vb.net with excel

i want to determine the first cell not empty in worksheet

i try with this :

With xlWorkSheet
lastrow = .Cells(.Rows.Count, 1).End(Excel.XlDirection.xlDown).Row
lastcol = .Cells(1, .Columns.Count).End(Excel.XlDirection.xlToRight).Column
End With

hope you undersand me