Avatar of randys106
Flag for United States of America

asked on 

Worksheet Change Syntax Troubles

I am trying to manually call the Worksheet_Change Subroutine.  My code looks like this...

Private Sub mySubroutine()
Call Worksheet_Change (Temp)
End Sub

Open in new window

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.


Microsoft ExcelMicrosoft Applications

Avatar of undefined
Last Comment

8/22/2022 - Mon