Compare Report for Record PeopleCode |
What I needed was a Macro that could scan the report for me and stop on either the column 1 having a value or column 8 having a value; both are highlighted in red above. This was my simple Macro that I executed when I wanted to quickly scan to the next change or to the next event.
Sub scan() Dim i As Long Dim s As Long Dim o As Long s = ActiveCell.Row For i = ActiveCell.Row To Rows.Count If Cells(i, 8).Value > " " Or Cells(i, 1) > " " Then o = i - s + 1 ActiveCell.Offset(o, 0).Select Exit For End If Next i End Sub
No comments:
Post a Comment