LinkBack URL
About LinkBacks
what is wrong with the code ?
Formula:
ActiveCell.Offset(0, -1).Value = ActiveCell.Offset(0, -2) * ActiveCell(F2) / ActiveCell(F3) - ActiveCell.Offset(0, -3)
help please!!!
what is wrong with this code ?
what is wrong with the code ?
Formula:ActiveCell.Offset(0, -1).Value = ActiveCell.Offset(0, -2) * ActiveCell(F2) / ActiveCell(F3) - ActiveCell.Offset(0, -3)
help please!!!
Last edited by segattoy; 01-27-2015 at 07:46 PM.
Will only work if active cell is column D or beyond...
ActiveCell.Offset(0, -1).Value = ActiveCell.Offset(0, -2).Value * ActiveSheet.Range("F2").Value / ActiveSheet.Range("F3").Value - ActiveCell.Offset(0, -3).Value
Please consider adding a * if I helped.
Where is the code?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
thanks the logical part work, but the result is wrong.
i will review the code but thanks anyway
Last edited by segattoy; 01-27-2015 at 08:14 PM.
I suspect you need some brackets in there somewhere.
Thank you so much, worked , i just need add the brackets kkk
Formula:ActiveCell.Offset(0, -1).Value = (ActiveCell.Offset(0, -2).Value * ActiveSheet.Range("F2").Value) / (ActiveSheet.Range("F3").Value - ActiveCell.Offset(0, -3).Value)
Last edited by segattoy; 01-27-2015 at 08:29 PM.
one more question kk i add one line to white the result in a textbox
Formula:TXTresultado.Text = ActiveCell.Offset(0, -1).Value
but i just want show 2 decimal place what i need do ?
TXTresultado.Text = format(ActiveCell.Offset(0, -1).Value , "#.##")
Last edited by Brendan_Floyde; 01-28-2015 at 06:21 AM. Reason: add code tags
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks