<div>
randys106<br />
<br />
Total cheat, but (assuming the sheet is &quot;Sheet1&quot;), what about replacing the Call line by...<br />

<pre><code id="code-8224909">Sheets(&quot;Sheet1&quot;).Cells(1, 1).Formula = Cells(1, 1).Formula</code></pre>
Regards,<br />
Brian.
</div>


randys106

Total cheat, but (assuming the sheet is "Sheet1"), what about replacing the Call line by...


Sheets("Sheet1").Cells(1, 1).Formula = Cells(1, 1).Formula

Regards,
Brian.

<div>
Yes its a cheat...and a damn beautiful one. &nbsp;I like it! &nbsp;It worked perfectly.
</div>


Yes its a cheat...and a damn beautiful one.  I like it!  It worked perfectly.

<div>
<div class="content wysiwyg-content">
I am trying to manually call the Worksheet_Change Subroutine. &nbsp;My code looks like this...<br />
<br />
<br />

<pre><code id="code-10-27382901-1">Private Sub mySubroutine()
…code…
Call Worksheet_Change (Temp)
…code…
End Sub</code></pre>
<br />
Temp is a named range. &nbsp;The error I get is &quot;Object Required&quot;.<br />
<br />
I have also tried things like &quot;$A$1:$A$1&quot; and its variations. &nbsp;Here I get a type mismatch error.<br />
<br />
I do not need the target to point to anything, I just need the subroutine to run.<br />
<br />
Ideas?<br />
<br />
<br />

</div>
</div>


I am trying to manually call the Worksheet_Change Subroutine.  My code looks like this...


(CODE)

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.

Ideas?




Worksheet Change Syntax Troubles

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.