Solved

pasting this formula

Posted on 2014-04-27
2
184 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 27

Accepted Solution

by:
MacroShadow earned 500 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
data scientists and AI 17 115
Is COM supported from Apache 1 66
Delphi: barcode reading on android platform 1 51
Link failure 16 35
What my article will show is if you ever had to do processing to a listbox without being able to just select all the items in it. My software Visual Studio 2008 crystal report v11 My issue was I wanted to add crystal report to a form and show…
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

828 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