Solved

Capture one value in streaming data

Posted on 2014-03-27
4
257 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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will be introduced to the member functions push_back and pop_back of the vector class. The video will teach the difference between the two as well as how to use each one along with its functionality.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

895 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

17 Experts available now in Live!

Get 1:1 Help Now