SnR.JPG

<div>
I wouldn't set it to run in the whole workbook unless you want all the occurrences of ABCD to be changed to ABCD1.<br />
Match case is a good idea.
</div>


I wouldn't set it to run in the whole workbook unless you want all the occurrences of ABCD to be changed to ABCD1.
Match case is a good idea.

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
&nbsp; &nbsp;I have a spreadsheet with formulas referencing a worksheet named &quot;ABCD&quot;. I also have a worksheet named &quot;ABCD1&quot;. &nbsp;whats the easiest way to change the sheet reference in the formulas from worksheet &quot;ABCD&quot; to &quot;ABCD1&quot;.<br />
<br />
Thanks 
</div>
</div>


Hi Experts,

   I have a spreadsheet with formulas referencing a worksheet named "ABCD". I also have a worksheet named "ABCD1".  whats the easiest way to change the sheet reference in the formulas from worksheet "ABCD" to "ABCD1".

Thanks 

Changing sheet reference in formulas

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