Results 1 to 9 of 9
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    delete cells boh! (2000 sr-1)

    The userform E-mail fill cells based a range in variuos sheets and dates.
    My prob:
    The first column of optionbutton fill cells base range of date the second column delete value in cells with the same range of date.
    for test use the CORPORATE.
    Insert in text box date 01/01/2000 and 31/12/2006 now click on first option button refered CORPORATE... the cells filled are 51 (see the refered label filled with a count in sheet GAF cell S1)...
    Now if i click on the second option button refered CORPORATE and use the same range of date the macro clear 50 cells and not 51 the cells 435 in column N not is cleared...WHY?

    sorry for dimension out 23k
    http://www.mytempdir.com/963951

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: delete cells boh! (2000 sr-1)

    When I try it, all entries in column N (including the one in row 435) are cleared, so I can't reproduce the problem.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: delete cells boh! (2000 sr-1)

    hummmmm....
    test:
    insert 01/01/2000 and 31/12/2006 press first optionbutton the label refered count 51 cells, ok.
    maintain the same date and press the second optionbutton(is to delete value), the label41 count zero but in column N still remain cell 435 not cleared...
    To be sure close the form and see in 435 i have CE , cell S1 count=1

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: delete cells boh! (2000 sr-1)

    I repeat: when enter 1/1/2000 in the first text box and 31/12/2006 in the second text box, then click the first option button labeled Corporate, and finally click the second option button labeled Corporate, all cells in column N are cleared. Also, S1 shows a blank (it contains 0, but zero values are not displayed)

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: delete cells boh! (2000 sr-1)

    now, peraph is a problem with my setting in Excel option refred the date?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: delete cells boh! (2000 sr-1)

    I don't see any problem. GAF!H435 contains 11, and this value occurs in CORPORATE!G2:G22 (in cell G10), so it is found by the MATCH function.

    I would set a breakpoint on the first line of CANCELLA_EMAIL_SETT (click in the line and press F9). When you click the second option button, the code will pause here. Press F8 to single-step through the code. After RNG has been set, check that it is the range G2:G22, and keep track of the value of RIGA. See what happens when RIGA = 435.

  7. #7
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: delete cells boh! (2000 sr-1)

    gosth!!!!!
    changed date from 31/05/2006 to 30/05/2006 (to the hand) in cell B435 and it work!
    Re-change in 31/05/2006 have still 1 in cell 435 and in S1????????????

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: delete cells boh! (2000 sr-1)

    Sorry, I can't explain this. I have set the date format on my PC to the same as yours (dd/mm/yyyy or gg/mm/aaaa), and I get the same result as before: N435 is cleared.

    You'll have to single-step through the code, as suggested in my previous reply, to see what happens. I know it is tedious, but I don't know another way.

  9. #9
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: delete cells boh! (2000 sr-1)

    gosth!
    With my Pc in office work!
    With my Pc in home not work!=gosth
    Tks for patience.

Posting Permissions

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