Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formual in macro
i am having a problem rewriting the formula in my macro, i'm trying to
multiple the value of a cell that is to rows over to the right, however it doesn't work as planned. any insight? Private Sub cmdAdd_Click() Dim Order As String Dim Index As Variant Dim nextrow As Long Order = txtOrder.Value With Range("K:K") Set c = .Find(Order, LookIn:=xlValues) If Not c Is Nothing Then firstAddress = c.Address Do Cells(c.Row, 2).Value = Cells(c.Row, 2).Value + ((Me.txtShip.Value / Me.txtPart.Value) * the value of a cell that is 2 rows to the right) Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address < firstAddress End If End With End Sub -- --Chip Smith-- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formual not working when 2003 WKB saved as 2007 Macro Enabled WKB | Excel Worksheet Functions | |||
some help with an IF formual or something like it | Excel Worksheet Functions | |||
WHAT DOES FORMUAL =C8+ 15 DO | Excel Discussion (Misc queries) | |||
Set Formual | Excel Discussion (Misc queries) | |||
what is mean by ^ in formual | Excel Programming |