I have a DGV that displays a list of approvers using the following code:

Code:
            Me.TblChangeApproveTableAdapter.FillByChangeID(Me._MasterBase4_0ItemMasterDataSet.tblChangeApprove, glbintCRNum)
            dgvSignList.DataSource = Me._MasterBase4_0ItemMasterDataSet
            dgvSignList.Height = 406
            dgvSignList.Width = 779
            dgvSignList.DataMember = "TblChangeApprove"
            dgvSignList.Columns(0).Visible = False
            dgvSignList.Columns(1).Visible = False
            dgvSignList.Columns(2).HeaderText = "Name"
            dgvSignList.Columns(2).Width = 275
            dgvSignList.Columns(3).HeaderText = "Job Title"
            dgvSignList.Columns(3).Width = 275
            dgvSignList.Columns(4).HeaderText = "Department"
            dgvSignList.Columns(4).Width = 225
            dgvSignList.Columns(5).Visible = False
            dgvSignList.Columns(6).Visible = False
            dgvSignList.Columns(7).Visible = False
            dgvSignList.Columns(8).Visible = False
            dgvSignList.Columns(9).Visible = False
No problem, the DGV lists exactly what I want from this table.

So what I do is use a DGV double_Click() event to select one of the persons displayed on the list:

Code:
            glbstrName = CStr(Me.dgvSignList.Rows(e.RowIndex).Cells(5).Value.ToString)
            RemoveApprover()
You will note that in the first code block above most of the columns have had .Visible = False.

So my problem is that the data I am interested in is in a column that .Visible = False and ONLY the fields with .Visible = True will provide a value for the variable in the second set of code. So how do I squeeze a value from a column that .Visible = False?