I have an excel file that has a Name in column 1 and a Flag (1 or 0) in column 2. Based on a login (section access) my macro can find the row (persons login name) I need to go to, but I can't seem to get to column 2. The code below will delete the row but how do I move to column 2 and change the number in that column?
sub MessageBox
Set oXL=CreateObject("Excel.Application")
set doc = ActiveDocument
doc.fields("DSMSYOUGET").SelectAll
set mySelection = doc.fields("DSMSYOUGET").GetSelectedValues