<div>
Looks like &nbsp;you want to loop through a few cells.<br />
Upload a simple workbook demonstrating the issue.
</div>


Looks like  you want to loop through a few cells.
Upload a simple workbook demonstrating the issue.

<div>
Sweet. &nbsp;<br />
<br />
Any chance you want to take a crack at my previous question that is still open?<br />
<br />
Same problem, bigger scale....<br />
<br />
Thanks either way!!!
</div>


Sweet.  

Any chance you want to take a crack at my previous question that is still open?

Same problem, bigger scale....

Thanks either way!!!

<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
I have this formula that I am trying to paste into vba:<br />
<br />
Formula:<br />
=Roundup((C10 * Constants!$F$4),0)<br />
<br />
What I have for vba (so far):<br />
<br />
= &quot;= Roundup((C&quot; &amp;&nbsp;i &amp;&nbsp;&quot;*&quot; constants!$F$4 &amp;&nbsp;i &amp;&nbsp;&quot;), 0)&quot;<br />
<br />
I think I am almost 'there' with this one; can somebody give me a shove over the finish line?<br />
<br />
thanks!
</div>
</div>


Hi, 

I have this formula that I am trying to paste into vba:

Formula:
=Roundup((C10 * Constants!$F$4),0)

What I have for vba (so far):

= "= Roundup((C" & i & "*" constants!$F$4 & i & "), 0)"

I think I am almost 'there' with this one; can somebody give me a shove over the finish line?

thanks!

pasting this formula in

A programming language is a formal constructed language designed to communicate instructions to a machine, particularly a computer. Thousands of different programming languages have been created, mainly in the computer field, and many more still are being created every year. The description of a programming language is usually split into the two components of syntax (form) and semantics (meaning). Some languages are defined by a specification document (for example, the C programming language is specified by an ISO Standard), while other languages (such as Perl) have a dominant implementation that is treated as a reference. Some languages have both, with the basic language defined by a standard and extensions taken from the dominant implementation being common.

Programming Languages-Other

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

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.