INSERT GRAPHIC HERE (include hyperlink in image)
Subtitle or Short Description Goes Here
| Private Sub Worksheet_Change(ByVal Target As Range) | |
| Dim i As Integer | |
| Dim j As Integer | |
| Offset = 10 'The distance between your input column and output column (missing -> frequency) change if you need to | |
| For i = 3 To 10 '3 here is the beginning row, 10 is the end row -> change accordingly | |
| For j = 2 To 5 '2 here is the beginning column (B), 5 is the end column (E) -> change accordingly | |
| If Not Intersect(Target, Cells(i, j)) Is Nothing Then | |
| missingVal = Cells(i, j).Value |
Related Setup: https://gist.github.com/hofmannsven/6814278
Related Pro Tips: https://ochronus.com/git-tips-from-the-trenches/