I'm attempting to create code that examines a value and, depending on it (OPGW or "Conductor"), executes either the OPGW macro or the Conductor macro in a cell further to the right. Then I want it to scroll down to the following line and repeat the process.
I want cell BG8 to execute the OPGW code if cell B8 is an OPGW cell, and cell BG9 to execute the Conductor code if cell B9 is a Conductor cell. The individual macros are not problematic, but it should be noticed that each macro is a very lengthy formula that SHOULD ONLY be executed in the active cell.
Sub WireUpdate()
N = Cells(Rows.Count, "A").End(xlUp).Row
CR = ActiveCell.Row()
With Range("BG8:BG" & N)
If ActiveSheet.Cells(CR, 2) = "OPGW" Then
Call OPGW2
Else: Call Conductor2
End If
End With