So I have a method that is passing in a sheet name and column name and I am trying to get the cell index and number of rows in that column based on that column name. I am not sure where to start this is my method
public static int GetColumnIndex(Excel.Worksheet worksheet, string columnName)
{
}