Hello everyone,
I'm here to ask for your help again.
I need to get the last used row from a specific column - I use only index of column, not letters for it and also i have them formatting using different colors for cells.
Any solution to how i could get the last used row from a specific column ??
What I have tried:
int nInLastCol = xlWorkSheet.Cells.Find("*", System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, Excel.XlSearchOrder.xlByColumns, Excel.XlSearchDirection.xlPrevious, false, System.Reflection.Missing.Value, System.Reflection.Missing.Value).Row;
It returns me for the last column from my sheet, the last used row in that column.
But i need for a particularly column not the last..