Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    196
    Thanks
    1
    Thanked 0 Times in 0 Posts

    set value of entire Range (2003 sp2)

    I have Range("B12:C21"), set to rngCO. When button is clicked, I want the values of this range to all be reset to zero (0). How do I do this?

    thanks,
    jackal

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

    Re: set value of entire Range (2003 sp2)

    Put the instruction

    rng = 0

    in the macro that is called by the button (if it is from the Forms toolbar) or in the On Click event procedure of the button (if it is from the Control Toolbox).

  3. #3
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    196
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: set value of entire Range (2003 sp2)

    OOOOOHH... If life could only be that easy!!!

    thanks once again!!

    jackal

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

    Re: set value of entire Range (2003 sp2)

    <img src=/S/blackteeth.gif border=0 alt=blackteeth width=20 height=20>

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: set value of entire Range (2003 sp2)

    Shouldn't that be:

    <code>
    rngCO = 0
    </code>
    Legare Coleman

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

    Re: set value of entire Range (2003 sp2)

    Yes, of course, but I think Jackal understood that.

Posting Permissions

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