Solved

pasting this formula

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Delphi Mdi application Child forms get behind control 7 216
Best book to learn C++ 4 80
What .NET website keeps me current? 9 70
Problem to error 4 61
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…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
This video teaches viewers about errors in exception handling.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

832 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