?
Solved

pasting this formula in

Posted on 2014-04-11
3
Medium Priority
?
171 Views
Last Modified: 2014-04-12
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!
0
Comment
Question by:BostonBob
3 Comments
 
LVL 22

Accepted Solution

by:
Flyster earned 2000 total points
ID: 39995628
Try this:

= "= Roundup((C" & i & "* Constants!$F$4), 0)"

Not sure why you had the variable i after $F$4.

Flyster
0
 
LVL 31

Expert Comment

by:hnasr
ID: 39995982
Looks like  you want to loop through a few cells.
Upload a simple workbook demonstrating the issue.
0
 

Author Comment

by:BostonBob
ID: 39996538
Sweet.  

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

Same problem, bigger scale....

Thanks either way!!!
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Suggested Courses
Course of the Month13 days, 15 hours left to enroll

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question