Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: iteration problem

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a work sheet where in column C and D where c1=c1+a1 and d1=d1+b1 etc, I have set the iteration in the "calculation" under tools to 1 yet when i enter a digit in A cell D also changes, same thing happens to C when numbers are entered in B I have tried c1=$c1+$a1 and D1=$d1+$b1 but still the same thing happens huh Help me pls colleen

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Colleen...
    Seems to kinda work...

    When I put =C1 + A1 in C1 all is well
    but if I place any similiar formulas in the same column, no dice...
    Could solve the problem in the change event...
    I'll wait and see if someone else can help you..

    Tom

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Private Sub Worksheet_Change(ByVal Target As Range)
    Select Case Target.Column
    Case 1
    Cells(Target.Row, 3).Value = _
    Cells(Target.Row, 3).Value + _
    Cells(Target.Row, 1).Value
    Case 2
    Cells(Target.Row, 4).Value = _
    Cells(Target.Row, 4).Value + _
    Cells(Target.Row, 2).Value
    End Select
    End Sub


    [ This Message was edited by: TsTom on 2002-04-28 09:16 ]

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thanks Tom, now a real silly question to enter the code I have to right click the worksheet tab and enter the code as is ..coll

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •