SteveM99
11-21-2018, 01:23 PM
I am trying to use the results of a formula in my case macro but cannot figure out code.
formula in cell c3 is an index match formula
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C3")) Is Nothing Then
Dim x As String
x = Range("c3").Text
Select Case x
Case "JAY": FF199_ONLY_JAY
End Select
End If
End Sub
formula in cell c3 is an index match formula
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C3")) Is Nothing Then
Dim x As String
x = Range("c3").Text
Select Case x
Case "JAY": FF199_ONLY_JAY
End Select
End If
End Sub