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

    suggestion.... (2000r-1)

    Hi Hans, perhaps i have found error and solved...
    (sorry for last day... on pvt msg)

    when i import txt file i use to set sheet with :

    set elenco sheet.....
    ......
    range (..........+riga ) = elelnco.range("..........+riga") & elelnco.range("..........+riga ") & elelnco.range("..........+riga")

    ecc...

    The error? i have forget the last elenco. and used only & range(".........." + riga)
    the line in error here
    range (..........+riga ) = elelnco.range("..........+riga") & elelnco.range("..........+riga ") & range("..........+riga")
    missing to set elenco.range(.....) ecc.!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!

    and naturally the rest of code not work correctly.....

    Now i am happy....

    But to not permit the similar error wath you suggest me?

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

    Re: suggestion.... (2000r-1)

    Sal,

    There is no general "recipe" to prevent programming errors. You'll have to check and recheck the code, and look for inconsistencies.
    It often helps to single-step through code (F8), and to be alert for unexpected or undesired results.

Posting Permissions

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