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
--
Message posted from
http://www.ExcelForum.com