Consulting

Results 1 to 4 of 4

Thread: Solved: return missing value

  1. #1

    Solved: return missing value

    with a macro, please....
    i want to insert in colum B the missing value in range from column A based a B1 to C1...
    started from B2 insert value from 45000001 to 45000080, 45000082 to 45000107, 45000109 to 45000149... 45034946 to 450040000

    naturally for test use only the first 8 digit of value in column A
    Sal
    1 help 1 pizza
    2 help 1 pizza 1 caff?
    3 help 1 pizza 1 caff? 1 mozzarella
    ...
    Spaghetti, Lasagne and Tortellini for the "Lady" ;-)

  2. #2
    VBAX Expert
    Joined
    Feb 2005
    Location
    Nanaimo, British Columbia, Cananda
    Posts
    568
    Location
    Hi sal21


    This help?

    Cheers,

    dr

  3. #3
    Quote Originally Posted by rbrhodes
    Hi sal21


    This help?

    Cheers,

    dr
    superb!
    tks.
    Only one.... but possible to no insert blank cell in column B during the copy of missing value?
    Sal
    1 help 1 pizza
    2 help 1 pizza 1 caff?
    3 help 1 pizza 1 caff? 1 mozzarella
    ...
    Spaghetti, Lasagne and Tortellini for the "Lady" ;-)

  4. #4
    Quote Originally Posted by rbrhodes
    Hi sal21


    This help?

    Cheers,

    dr
    dont worry for last reply, solved...
    tks for all...

    Ahhhhhhhhhhhhh...
    Tks again for good explain in code.
    Good user not is only make code, but good user is who understand the code!
    Sal
    1 help 1 pizza
    2 help 1 pizza 1 caff?
    3 help 1 pizza 1 caff? 1 mozzarella
    ...
    Spaghetti, Lasagne and Tortellini for the "Lady" ;-)

Posting Permissions

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