Solved

pasting this formula in

Posted on 2014-04-11
3
155 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 500 total points
Comment Utility
Try this:

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

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

Flyster
0
 
LVL 30

Expert Comment

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

Author Comment

by:BostonBob
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article will show, step by step, how to integrate R code into a R Sweave document
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now