selecting a row by header row in VBA

W

wraithlead

I know this code probably isn't the most efficient, but i'm not worrie
about that, since it mostly does what i need. At the end, for th
underlined, i needed to select a row, by the header row instead of th
distance from the active cell.

Sub McStatTol()
' Keyboard Shortcut: Ctrl+Shift+r
Range("AK8").Select
Do
ActiveCell.Clear
If Not ActiveCell.Offset(0, -1) & ActiveCell.Offset(0, -2) = "
Then
If ActiveCell.Offset(0, -2) > ActiveCell.Offset(0, -1) Then
ActiveCell.Value = ActiveCell.Offset(0, -2)
Else
ActiveCell.Value = ActiveCell.Offset(0, -1)
End If
End If
ActiveCell.Offset(1, 0).Select

_Loop_While_Not_ActiveCell.Offset(0,_-35).Value_=_\"\"_


End Sub


Is there any way to say something like -Loop While Not 'ID Number'
""-?

Thanks in advance,
00
 
Top