?
Solved

pasting this formula

Posted on 2014-04-27
2
Medium Priority
?
195 Views
Last Modified: 2014-04-27
Hi All,

I have this formula:

=Roundup((C10 * constants!$F$4),0)    ...and to paste this into VBA I have....
= "=Roundup((C" & i & "*" Constants!$F$4 & i & "),0)"

So if I have this formula:
=VBAround(Tickets!V10,,Round!B$1)   ....how would I paste this into vba...?



thanks!
0
Comment
Question by:BostonBob
2 Comments
 
LVL 28

Accepted Solution

by:
MacroShadow earned 2000 total points
ID: 40025508
"=VBAround(Tickets!V10,,Round!B$1)"
"=VBAround(Tickets!V" & i & ",,Round!B$1)"
0
 

Author Comment

by:BostonBob
ID: 40026530
One quick follow up:

What would this look like if "Tickets" was instead "Red Line"?

"=VBAround(Tickets!V" & i & ",,Round!B$1)"

Would that be?....

"=VBAround(Red Line!V" & i & ",,Round!B$1)"
0

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared o…
When we want to run, execute or repeat a statement multiple times, a loop is necessary. This article covers the two types of loops in Python: the while loop and the for loop.
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

584 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