D
Daniel Jones
Guys-
Is there a way to run a procedure thats stored in a module on a
worksheet change event? When cell J1 changes, I'd like to run the
procedure ChangeRows() which is stored in a module. However, this
does not seem to be calling the procedure. Can anyone help? Thanks!
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Comment here
Case "$J$1"
Call ChangeRows
Case Else
End Select
End Sub
Is there a way to run a procedure thats stored in a module on a
worksheet change event? When cell J1 changes, I'd like to run the
procedure ChangeRows() which is stored in a module. However, this
does not seem to be calling the procedure. Can anyone help? Thanks!
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Comment here
Case "$J$1"
Call ChangeRows
Case Else
End Select
End Sub