?
Solved

Capture one value in streaming data

Posted on 2014-03-27
4
Medium Priority
?
266 Views
Last Modified: 2014-03-29
Hi All,

I am wondering how to capture  a single value in VBA using this kind of notation:

 "= Round(constants!AO" & i & ",constants!AP" & i & ")"

The problem is that I can capture the cell in question but the cell value is changing in real time.

I just want to be able to capture a single value at the "event" moment; again, I would like the form to be in the form above if possible.

I think what I am looking for is a copy and paste (values only) just before the line of code above.

Copy from Column A to Column B would be a helpful example.  

thanks,
0
Comment
Question by:BostonBob
  • 2
  • 2
4 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39960839
Try

evaluate("= Round(constants!AO" & i & ",constants!AP" & i & ")")
0
 

Author Comment

by:BostonBob
ID: 39962568
Hi,

So I am using:

.Cells(oCell1.row, "P").value = Evaluate("= Round(Counter!W" & i1 & ",Counter!AG" & i1 & ")")

column W + row i, in this case, equals:  14.83918505
Column AG + row i, in this case, equals: 5.

I am getting an answer of: 14.84....on the left hand side of the above equation.  So, I am almost there but the rounding portion is cooperating as I would like (or probably I am missing something).

Call me crazy, but I thought that if I had 5 for the significant digits figure i should end up with:   14.83919, not 14.84.

Please comment.

thanks!
0
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 2000 total points
ID: 39963015
can you upload something for testing?
0
 

Author Closing Comment

by:BostonBob
ID: 39964503
I was missing a comma. Now it works. Thanks!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Suggested Courses
Course of the Month15 days, 16 hours left to enroll

850 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