Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# pasting this formula

Posted on 2014-04-27
Medium Priority
188 Views
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
Question by:BostonBob
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 27

Accepted Solution

ID: 40025508
"=VBAround(Tickets!V10,,Round!B\$1)"
"=VBAround(Tickets!V" & i & ",,Round!B\$1)"
0

Author Comment

ID: 40026530

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

Question has a verified solution.

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

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.
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
The viewer will learn how to user default arguments when defining functions. This method of defining functions will be contrasted with the non-default-argument of defining functions.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
###### Suggested Courses
Course of the Month11 days, 13 hours left to enroll