Q-28691571.xls

<div>
<div class="content wysiwyg-content">
I have a simple routine that copies and pastes formulas from one sheet to another when user clicks a button, let's say the following is the code:<br />

<pre><code id="code-8269607">ThisWorkbook.Worksheets(&quot;formulasheet&quot;).Range(&quot;A1:D500&quot;).Copy
    ThisWorkbook.ActiveSheet.Range(&quot;A1:D500&quot;).PasteSpecial xlPasteFormulas
    ThisWorkbook.ActiveSheet.Range(&quot;A1:D500&quot;).PasteSpecial xlPasteFormats</code></pre>
<br />
If I wanted to store there formulas as text so that they are not calculating when not needed and have '= in front of all of them on formulasheet tab, is there a way to write a code so that it removes ' when pasting values so that formulas become formulas again?
</div>
</div>


I have a simple routine that copies and pastes formulas from one sheet to another when user clicks a button, let's say the following is the code:


If I wanted to store there formulas as text so that they are not calculating when not needed and have '= in front of all of them on formulasheet tab, is there a way to write a code so that it removes ' when pasting values so that formulas become formulas again?

Excel VBA: Copy paste a lrage range and remove ' in front in each cell

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

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.