I am trying to activate a macro by clicking in a cell. I have the macro working if i click on an empty cell or a cell with general text in it. But I have a cell with an =’s formula in it and when i use the below code it does not activate the macro.
Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Selection.Count = 1 Then If Not Intersect(Target, Range("B37")) Is Nothing Then Worksheets("DaysEditor").Activate Sheets("DaysEditor").Columns("C:LY").Hidden = False Sheets("DaysEditor").Columns("C:EX").Hidden = True Sheets("DaysEditor").Range("A1").Select End If End If End Sub
This code works perfectly on a cell that doesn’t have a formula but will not work on cells with formulas in them. Please help me get this to work with a cell with a formula in it.