I am trying to manually call the Worksheet_Change Subroutine. My code looks like this...
Private Sub mySubroutine()
Call Worksheet_Change (Temp)
Temp is a named range. The error I get is "Object Required".
I have also tried things like "$A$1:$A$1" and its variations. Here I get a type mismatch error.
I do not need the target to point to anything, I just need the subroutine to run.