<div>
I can't reproduce your error the way you describe it. &nbsp;This is pretty common though. &nbsp;Is there any reason this has to be set with the FormulaR1C1 property? &nbsp;Just use the Value property which is the default property of the range.<br />

<pre><code id="code-475680">DestSheet.Range(&quot;I10&quot;) = &quot;&quot;
</code></pre>
</div>


I can't reproduce your error the way you describe it.  This is pretty common though.  Is there any reason this has to be set with the FormulaR1C1 property?  Just use the Value property which is the default property of the range.


DestSheet.Range("I10") = ""


<div>
No that formula would work as well, except that it still leaves a placemarker of some kind in the cell. The cell does not real remain empty like it would if you use the delete key and becuase of this th eother formauls on teh page that look at that cell see something there and answer incorrectly.
</div>


No that formula would work as well, except that it still leaves a placemarker of some kind in the cell. The cell does not real remain empty like it would if you use the delete key and becuase of this th eother formauls on teh page that look at that cell see something there and answer incorrectly.

<div>
It seems to place a space intead of nothing in the cell.
</div>


It seems to place a space intead of nothing in the cell.

<div>
well you can just delete the cell contents via VBA<br />
<br />
Cheers<br />
Dave<br />
<br />

<pre><code id="code-475691">DestSheet.Range(&quot;I10&quot;).ClearContents
</code></pre>
</div>


well you can just delete the cell contents via VBA

Cheers
Dave



DestSheet.Range("I10").ClearContents


<div>
<div class="content wysiwyg-content">
I am using an FormulaR1C1 statement on my VBscript.<br />
<br />
DestSheet.Range(&quot;I10&quot;).For<wbr />mulaR1C1 = &quot;&quot;<br />
<br />
The problem with it is that other cells rely on it to be an empty cell. But it actaully places something unseen in the cell the the formulas see. If I use teh delete key its fine. How can I change teh formula that I use to delete anyhting in teh cell without deleteing the cell or changing it's format?
</div>
</div>


I am using an FormulaR1C1 statement on my VBscript.

DestSheet.Range("I10").FormulaR1C1 = ""

The problem with it is that other cells rely on it to be an empty cell. But it actaully places something unseen in the cell the the formulas see. If I use teh delete key its fine. How can I change teh formula that I use to delete anyhting in teh cell without deleteing the cell or changing it's format?

FormulaR1C1 = &quot;&quot;  Problem

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

FormulaR1C1 = &quot;&quot; Problem

FormulaR1C1 = "" Problem