private void btnRedactedInfo_Click(object sender, RibbonControlEventArgs e)
    {
        Excel.Worksheet activeWorksheet = Globals.ThisAddIn.GetActiveWorksheet();
        int intRow = 2;

        while (true)
        {
            Range intRange = activeWorksheet.get_Range("W" + intRow);
            if (intRange.Value == null)
            {
                break;
            }
            lstRedactedNum.Add(intRange.Value);
            intRow++;
        }


        rClient rClient = new rClient();
        rClient.httpUsername = Settings.Default["Username"].ToString();
        rClient.httpPassword = Settings.Default["Password"].ToString();

        string strReponse = string.Empty;
        for (int i = 0; i < lstRedactedNum.Count; i++)
        {
            rClient.endPoint = "https://redacted.com/api/now/table/incident?sysparm_query=number%" + lstRedactedNum[i] + "&sysparm_fields=number%2Csys_id%2Cdescription&sysparm_limit=1";
            strReponse = rClient.makeReqest();
            System.Windows.Forms.MessageBox.Show(strReponse);
        }
        //txtResponse.Text = strReponse;
        lstIncidentNum.Clear();