Forum Discussion
Need help with VBA code
The below piece of code, in the attached macro, is not returning the expected result. The column 'Reference Visit', in the 'All Visits' tab, remains empty. Section of code: ' Check for specific...
If cell.Value = "Visit Sequence" Then visitColAll = cell.Column
sets visitColAll to 4 (column D).
However, the values you are looking for in the Select Case ... End Select block are in column 5 (column E).
Embarassing! 😠Thank you!