Excel.Workbook activeWorkBook =Globals.ThisAddIn.Application.ActiveWorkbook;
Excel.Worksheet activeWorkSheet = activeWorkBook.ActiveSheet;
Excel.Range colRange = activeWorkSheet.Columns["A:A"];
Excel.Range resultActionFirstRange = null;
Excel.Range resultActionCurrentRange = null;
List<Excel.Range> ActionRangeList = new List<Excel.Range>();

string searchActionLabel = "Action=>";
string searchDBLabel = "DatabaseName=>";
string searchTblLabel = "TableName=>";

resultActionCurrentRange = colRange.Find(searchActionLabel, Type.Missing, Excel.XlFindLookIn.xlValues, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, false, Type.Missing, Type.Missing);


        //get action
        while (resultActionCurrentRange != null)
        {
            if (resultActionFirstRange == null)
            {
                resultActionFirstRange = resultActionCurrentRange;
                ActionRangeList.Add(resultActionFirstRange);
            }

            else if (resultActionCurrentRange.get_Address(Excel.XlReferenceStyle.xlA1) == resultActionFirstRange.get_Address(Excel.XlReferenceStyle.xlA1))
            {
                break;
            }

            resultActionCurrentRange = colRange.FindNext(resultActionCurrentRange);
            ActionRangeList.Add(resultActionCurrentRange);
            MessageBox.Show("Range is:" + resultActionCurrentRange.Column.ToString() + resultActionCurrentRange.Row.ToString());
            MessageBox.Show("Range list count is: " + ActionRangeList.Count.ToString());
        }