<div>
You can test for a string greater than 0 characters in the source cell, ie this code will do nothing if &nbsp;SourceSheet.Cells(0 + Student, 2).Value) is empty<br />
<br />
Cheers<br />
Dave<br />
<br />

<pre><code id="code-475702">If Len(SourceSheet.Cells(0 + Student, 2).Value) &gt; 0 Then DestSheet.Range(&quot;J11&quot;) = SourceSheet.Cells(0 + Student, 2)
</code></pre>
</div>


You can test for a string greater than 0 characters in the source cell, ie this code will do nothing if  SourceSheet.Cells(0 + Student, 2).Value) is empty

Cheers
Dave



If Len(SourceSheet.Cells(0 + Student, 2).Value) > 0 Then DestSheet.Range("J11") = SourceSheet.Cells(0 + Student, 2)


<div>
This solution works best for the script I'm working with, when using the If Len script is tends to skip certain fields in the worksheet and is also longer.
</div>


This solution works best for the script I'm working with, when using the If Len script is tends to skip certain fields in the worksheet and is also longer.

<div>
<div class="content wysiwyg-content">
Is there a way to change these so that if the Source Cell is empty that they either does nothing or places a vbNullString ? Currently it places a space when there is nothing there.<br />
<br />
&nbsp; &nbsp; &nbsp; DestSheet.Range(&quot;I10&quot;) = SourceSheet.Cells(0 + Student, 1) &amp;&nbsp;&quot; &quot;&nbsp;&amp; SourceSheet.Cells(0 + Student, 2)<br />
&nbsp; &nbsp; &nbsp; DestSheet.Range(&quot;J11&quot;) = SourceSheet.Cells(0 + Student, 2)<br />
<br />

</div>
</div>


Is there a way to change these so that if the Source Cell is empty that they either does nothing or places a vbNullString ? Currently it places a space when there is nothing there.

      DestSheet.Range("I10") = SourceSheet.Cells(0 + Student, 1) & " " & SourceSheet.Cells(0 + Student, 2)
      DestSheet.Range("J11") = SourceSheet.Cells(0 + Student, 2)



VB Script Formula 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.