asked on

Capture one value in streaming data

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,

Saqib Husain

Try

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

BostonBob

ASKER

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!

ASKER CERTIFIED SOLUTION

Saqib Husain

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

BostonBob

ASKER

I was missing a comma. Now it works. Thanks!